eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_ROI_TRANSACTION dependencies on PO_HEADERS_ALL

Line 17: l_po_header_id po_headers_all.po_header_id%type;

13: n IN OUT NOCOPY BINARY_INTEGER,
14: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
15: x_header_record IN rcv_roi_preprocessor.header_rec_type
16: ) IS
17: l_po_header_id po_headers_all.po_header_id%type;
18: l_return_status VARCHAR2(1) :='S';
19: l_complex_flag varchar2(1);
20: l_interface_source_code rcv_transactions_interface.interface_source_code%type;
21: BEGIN

Line 2784: ***** statement so that it will drive through PO_HEADERS_ALL

2780:
2781: /***** Bug # 1553154
2782: ***** There was a performance issue since the cursor COUNT_DISTRIBUTIONS
2783: ***** was driving through PO_LINE_LOCATIONS_ALL. Modified the Select
2784: ***** statement so that it will drive through PO_HEADERS_ALL
2785: ***** followed by PO_LINES_ALL which is followed by PO_LINE_LOCATIONS_ALL
2786: ***** so that there is an improvement in performance.
2787: *****/
2788: CURSOR distributions(

Line 2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL

2862: ORDER BY NVL(pll.promised_date, pll.need_by_date);
2863:
2864: /***** Bug # 1553154
2865: ***** There was a performance issue since the cursor DISTRIBUTIONS
2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
2867: ***** Modified the Select statement so that it will drive through
2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
2869: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in

Line 2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by

2864: /***** Bug # 1553154
2865: ***** There was a performance issue since the cursor DISTRIBUTIONS
2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
2867: ***** Modified the Select statement so that it will drive through
2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
2869: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
2871: ***** Performance
2872: *****/

Line 9800: l_po_header_id po_headers_all.po_header_id%type;

9796: l_converted_distribution_qty NUMBER;
9797: l_distribution_qty NUMBER;
9798: l_converted_transaction_qty NUMBER;
9799: l_ship_unit po_line_locations.unit_meas_lookup_code%TYPE;
9800: l_po_header_id po_headers_all.po_header_id%type;
9801: l_return_status VARCHAR2(1) :='S';
9802: l_complex_flag varchar2(1);
9803:
9804: /* Bug 5354379 */

Line 9823: * l_po_num definition from NUMBER to po_headers_all.segment1%type

9819:
9820: /* Bug 5354379 */
9821: /** Bug:6030094
9822: * PO number can be alpha numeric. So changing the
9823: * l_po_num definition from NUMBER to po_headers_all.segment1%type
9824: */
9825: l_po_num po_headers_all.segment1%type := null;
9826: l_po_line_num NUMBER := 0;
9827: l_po_line_loc_num NUMBER := 0;

Line 9825: l_po_num po_headers_all.segment1%type := null;

9821: /** Bug:6030094
9822: * PO number can be alpha numeric. So changing the
9823: * l_po_num definition from NUMBER to po_headers_all.segment1%type
9824: */
9825: l_po_num po_headers_all.segment1%type := null;
9826: l_po_line_num NUMBER := 0;
9827: l_po_line_loc_num NUMBER := 0;
9828: l_po_dist_num NUMBER := 0;
9829: /* Bug 5354379 */

Line 10343: from po_headers_all

10339: RCV_TRX_QTY_EXCEEDS_AVAILABLE */
10340: BEGIN
10341: select segment1
10342: into l_po_num
10343: from po_headers_all
10344: where po_header_id = x_po_transferrec.po_head_id;
10345:
10346: select line_num
10347: into l_po_line_num

Line 11841: l_po_header_id po_headers_all.po_header_id%type;

11837: n IN OUT NOCOPY BINARY_INTEGER,
11838: temp_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
11839: x_header_record IN rcv_roi_preprocessor.header_rec_type
11840: ) IS
11841: l_po_header_id po_headers_all.po_header_id%type;
11842: l_return_status VARCHAR2(1) :='S';
11843: l_complex_flag varchar2(1);
11844:
11845: BEGIN

Line 15748: l_po_currency po_headers_all.currency_code%type;

15744: l_lsl_exists NUMBER := 0;
15745: l_rsl_qty NUMBER;
15746: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
15747: -- Bug 7607281
15748: l_po_currency po_headers_all.currency_code%type;
15749: l_po_rate_type po_headers_all.rate_type%type;
15750: l_po_rate_date po_headers_all.rate_date%type;
15751: l_sec_rsl_qty NUMBER;
15752: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;

Line 15749: l_po_rate_type po_headers_all.rate_type%type;

15745: l_rsl_qty NUMBER;
15746: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
15747: -- Bug 7607281
15748: l_po_currency po_headers_all.currency_code%type;
15749: l_po_rate_type po_headers_all.rate_type%type;
15750: l_po_rate_date po_headers_all.rate_date%type;
15751: l_sec_rsl_qty NUMBER;
15752: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;
15753: l_lsl_id NUMBER;

Line 15750: l_po_rate_date po_headers_all.rate_date%type;

15746: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
15747: -- Bug 7607281
15748: l_po_currency po_headers_all.currency_code%type;
15749: l_po_rate_type po_headers_all.rate_type%type;
15750: l_po_rate_date po_headers_all.rate_date%type;
15751: l_sec_rsl_qty NUMBER;
15752: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;
15753: l_lsl_id NUMBER;
15754: l_rate NUMBER;

Line 15954: FROM po_headers_all

15950: END IF;
15951: -- Bug 7607281
15952: SELECT currency_code, rate_type, rate_date, rate
15953: INTO l_po_currency, l_po_rate_type, l_po_rate_date, l_po_rate
15954: FROM po_headers_all
15955: WHERE po_header_id = x_cascaded_table(n).po_header_id;
15956:
15957: IF (g_asn_debug = 'Y') THEN
15958: asn_debug.put_line('l_po_currency : ' || l_po_currency);