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.PO_COPYDOC_S1 dependencies on PO_LINE_LOCATIONS_ALL

Line 1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;

1343: x_secondary_quantity PO_LINES_ALL.SECONDARY_QUANTITY%TYPE := NULL;
1344: --
1345:
1346: -- Bug 4958300
1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1349: --
1350:
1351: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;

Line 1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;

1344: --
1345:
1346: -- Bug 4958300
1347: l_line_value_basis PO_LINE_LOCATIONS_ALL.value_basis%type;
1348: l_line_matching_basis PO_LINE_LOCATIONS_ALL.matching_basis%type;
1349: --
1350:
1351: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;
1352:

Line 3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

3327:
3328: --: use local vars for this to handle BPA case
3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:
3335: BEGIN

Line 3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;

3328: --: use local vars for this to handle BPA case
3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:
3335: BEGIN
3336:

Line 3549: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;

3545: x_orig_quotation_class_code po_headers.quotation_class_code%TYPE := NULL;
3546:
3547: --< Shared Proc FPJ Start >
3548: l_orig_txn_flow_header_id
3549: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE;
3550: l_generate_new_accounts BOOLEAN := FALSE;
3551: --< Shared Proc FPJ End >
3552: l_calling_program VARCHAR2(30); --
3553: l_return_status VARCHAR2(1); --

Line 4763: FROM po_lines_all pl, po_line_locations_all pll

4759: -- Update POP Dates only if delivery event is not used.
4760:
4761: SELECT pl.CLM_DELIVERY_EVENT_CODE
4762: INTO l_clm_delivery_event_code
4763: FROM po_lines_all pl, po_line_locations_all pll
4764: WHERE pll.LINE_LOCATION_ID = p_from_pk_value
4765: AND pll.po_line_id = pl.po_line_id;
4766:
4767: UPDATE PO_LINE_LOCATIONS_ALL

Line 4767: UPDATE PO_LINE_LOCATIONS_ALL

4763: FROM po_lines_all pl, po_line_locations_all pll
4764: WHERE pll.LINE_LOCATION_ID = p_from_pk_value
4765: AND pll.po_line_id = pl.po_line_id;
4766:
4767: UPDATE PO_LINE_LOCATIONS_ALL
4768: SET uda_template_id = x_po_shipment_record.uda_template_id,
4769: clm_period_perf_end_date = decode(l_clm_delivery_event_code, --
4770: null, x_po_shipment_record.clm_period_perf_end_date,
4771: null),

Line 4781: FROM po_line_locations_all

4777: END IF;
4778:
4779: SELECT UDA_TEMPLATE_ID
4780: INTO l_template_id
4781: FROM po_line_locations_all
4782: WHERE LINE_LOCATION_ID = p_from_pk_value;
4783:
4784: IF l_template_id IS NULL THEN
4785: RETURN;