rejected and returned quantities and the days between the rejected and returned quantities to the Vendor

Client

MOTOROLA

Technical Design

Report to show the rejected and returned quantities and the days between the rejected and returned quantities to the Vendor

 

       Approvals:

Name	Title	Date

Contents

Overview.................................................................................................................................................... 3

High Level program information............................................................................................................ 4

Concurrent program details.................................................................................................................... 4

Parameter details...................................................................................................................................... 5

SRS screen............................................................................................................................................... 6

Sample Report.......................................................................................................................................... 7

SQL script.................................................................................................................................................. 8

Open/Close Issues................................................................................................................................... 9

 

Overview

This is to describe about the report, which generates the rejected and returned quantity after inspection and days between rejected and returned quantities.

The report ‘Motorola- Report of items which are rejected and returned to vendor’ will provide the following details PO header ID, Item ID, Item description, rejected quantity, returned quantity, rejected date, returned date, days between rejected and returned items and the vendor name.

The concurrent request Motorola-Report for rejected and returned quantity to the vendor ’ is attached to Purchasing responsibility.

The report can be generated for particular vendor or for all the vendors.

 

High level program information

The following tables and columns are used to retrieve the data in the report.

Table – Column Details:

Table Name	Column Name
RCV_TRANSACTIONS	PO_HEADER_ID, QUANTITY (REJECTED, RETURNED) TRANSACTION_DATE (REJECTED, RETURNED)
PO_HEADERS_ALL	PO_HEADER_ID VENDOR_ID
PO_LINES_ALL	ITEM_ID ITEM_DESCRIPTION
PO_VENDORS	VENDOR_NAME

Concurrent Program Details:

Name	Details
Program	MOT-Report for rejected and returned quantities
Short name	MOT_REJECTED_RETURNED_ITEMS
Application	MOT Application
Executable	MOT_PO_REPORT
Output Format	HTML
Output Style	Potrait
Report Name	MOT_PO_REPORT.rdf
Location	D:\oracle\prodappl\mot\11.5.0\reports\US

 

Parameter Details:

Sequence	Parameter Name	Parameter Description	Required? (Yes/No)	Default Value	Value Set
10	Vendor name	Vendor name	No	All	Vendor name

SRS SCREEN

Sample Report ;

SQL Script:

/*============================================================*/

REM Query to retrieve the rejected and returned items after inspection to the vendor and the days between rejected and returned quantities.

REM Client : Motorola.

REM 11-May-2005  Created by : Deepika

/*===========================================================*/

                    

select distinct a.po_header_id,c.item_id,c.item_description,a.quantity QTY_REJECTED,b.quantity QTY_RETURNED,

a.transaction_date REJECTED_DATE,b.transaction_date RETURNED_DATE,

b.transaction_date-a.transaction_date Days,e.vendor_name

from

(select po_header_id,quantity,transaction_type,transaction_date from po.rcv_transactions where

transaction_type in ('REJECT')) a,

(select po_header_id,quantity,transaction_type,transaction_date from po.rcv_transactions where

transaction_type in ('RETURN TO VENDOR')) b,

po.po_lines_all c,

po.po_headers_all d,

po.po_vendors e

where a.po_header_id=b.po_header_id and

a.po_header_id=c.po_header_id and

a.po_header_id=d.po_header_id and

d.vendor_id=e.vendor_id and

e.vendor_name=:vendorname

/*======================End-of-Program==========================*/

 

Open/Closed Issues

Open issues

Sno.	Issue description	Resolution	Owner

Closed issues

Sno.	Issue description	Resolution	Owner