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_AUTO_DIST_PROCESS_PVT dependencies on PO_LINE_LOCATIONS

Line 49: l_drop_ship_flag po_line_locations.drop_ship_flag%type;

45: x_conversion_rate NUMBER := 1;
46: x_gl_date_option VARCHAR2(25);
47: l_uom_conversion_rate MTL_UOM_CONVERSIONS.conversion_rate%TYPE := 1;
48: l_currency_conversion_rate PO_HEADERS_ALL.rate%TYPE := 1;
49: l_drop_ship_flag po_line_locations.drop_ship_flag%type;
50: l_from_type_lookup_code po_headers_all.TYPE_LOOKUP_CODE%type;
51: l_amount_ordered NUMBER;
52: l_rownum NUMBER;
53: l_charge_account_id NUMBER;

Line 406: FROM po_line_locations_draft_all

402: l_progress := '210';
403: BEGIN
404: SELECT NVL(drop_ship_flag,'N')
405: INTO l_drop_ship_flag
406: FROM po_line_locations_draft_all
407: WHERE line_location_id= p_lines.line_loc_id_tbl(i)
408: AND draft_id = po_autocreate_params.g_draft_id;
409: EXCEPTION
410: WHEN OTHERS THEN

Line 419: po_line_locations_draft_all poll

415: BEGIN
416: SELECT pdi.amount_ordered
417: INTO l_amount_ordered
418: FROM po_distributions_interface pdi,
419: po_line_locations_draft_all poll
420: WHERE pdi.interface_header_id = p_lines.intf_header_id_tbl(i)
421: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
422: AND poll.line_location_id = p_lines.line_loc_id_tbl(i)
423: AND poll.draft_id = po_autocreate_params.g_draft_id;

Line 461: po_line_locations_draft_all poll

457: l_progress := '250';
458: SELECT COUNT(*)
459: INTO l_dist_count
460: FROM po_distributions_interface pdi,
461: po_line_locations_draft_all poll
462: WHERE pdi.interface_header_id = p_lines.intf_header_id_tbl(i)
463: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
464: AND poll.draft_id =po_autocreate_params.g_draft_id
465: AND poll.line_location_id = p_lines.line_loc_id_tbl(i);

Line 707: po_line_locations_draft_all poll

703: pdi.clm_fms_case_number,
704: pdi.clm_agency_acct_identifier,
705: 'NEW'
706: FROM po_distributions_interface pdi,
707: po_line_locations_draft_all poll
708: WHERE pdi.interface_header_id = p_lines.intf_header_id_tbl(i)
709: AND pdi.interface_line_id = p_lines.intf_line_id_tbl(i)
710: AND poll.draft_id =po_autocreate_params.g_draft_id
711: AND poll.line_location_id = p_lines.line_loc_id_tbl(i) ; --

Line 851: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL & PO_DISTRIBUTIONS_ALL has still not been populated

847: poll.price_override ,
848: poll.payment_type ,
849: pod.distribution_type ,
850: pod.rate
851: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL & PO_DISTRIBUTIONS_ALL has still not been populated
852: Hence po_distributions_draft_all & po_line_locations_draft_all needs to be used
853: */
854: FROM po_distributions_draft_all pod,
855: po_line_locations_draft_all poll

Line 852: Hence po_distributions_draft_all & po_line_locations_draft_all needs to be used

848: poll.payment_type ,
849: pod.distribution_type ,
850: pod.rate
851: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL & PO_DISTRIBUTIONS_ALL has still not been populated
852: Hence po_distributions_draft_all & po_line_locations_draft_all needs to be used
853: */
854: FROM po_distributions_draft_all pod,
855: po_line_locations_draft_all poll
856: WHERE poll.po_line_id = p_po_line_id

Line 855: po_line_locations_draft_all poll

851: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL & PO_DISTRIBUTIONS_ALL has still not been populated
852: Hence po_distributions_draft_all & po_line_locations_draft_all needs to be used
853: */
854: FROM po_distributions_draft_all pod,
855: po_line_locations_draft_all poll
856: WHERE poll.po_line_id = p_po_line_id
857: AND pod.line_location_id = poll.line_location_id
858: AND pod.req_distribution_id IS NULL;
859:

Line 1153: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated

1149: prd.funded_value,
1150: NULL, --prd.quantity_funded,
1151: NULL, --prd.amount_funded,
1152: prd.funded_value
1153: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1154: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1155: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1156: po_req_distributions_all prd ,
1157: po_requisition_lines_all prl

Line 1154: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/

1150: NULL, --prd.quantity_funded,
1151: NULL, --prd.amount_funded,
1152: prd.funded_value
1153: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1154: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1155: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1156: po_req_distributions_all prd ,
1157: po_requisition_lines_all prl
1158: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)

Line 1155: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,

1151: NULL, --prd.amount_funded,
1152: prd.funded_value
1153: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1154: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1155: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1156: po_req_distributions_all prd ,
1157: po_requisition_lines_all prl
1158: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1159: AND prd.requisition_line_id = p_lines.requisition_line_id_tbl(i)

Line 1321: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated

1317: NULL ,
1318: DECODE(p_lines.order_type_lookup_code_tbl(i),'QUANTITY',poll.quantity) ,
1319: DECODE(p_lines.order_type_lookup_code_tbl(i),'AMOUNT',poll.amount) ,
1320: NULL
1321: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1322: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1323: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1324: po_line_locations_interface polli
1325: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)

Line 1322: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/

1318: DECODE(p_lines.order_type_lookup_code_tbl(i),'QUANTITY',poll.quantity) ,
1319: DECODE(p_lines.order_type_lookup_code_tbl(i),'AMOUNT',poll.amount) ,
1320: NULL
1321: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1322: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1323: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1324: po_line_locations_interface polli
1325: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1326: AND poll.line_location_id = polli.line_location_id

Line 1323: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,

1319: DECODE(p_lines.order_type_lookup_code_tbl(i),'AMOUNT',poll.amount) ,
1320: NULL
1321: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1322: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1323: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1324: po_line_locations_interface polli
1325: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1326: AND poll.line_location_id = polli.line_location_id
1327: AND poll.payment_type <> 'ADVANCE';

Line 1324: po_line_locations_interface polli

1320: NULL
1321: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1322: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1323: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1324: po_line_locations_interface polli
1325: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1326: AND poll.line_location_id = polli.line_location_id
1327: AND poll.payment_type <> 'ADVANCE';
1328:

Line 1433: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated

1429: pod.expenditure_organization_id ,
1430: pod.expenditure_item_date ,
1431: PO_AUTOCREATE_PARAMS.g_sys.sob_id ,
1432: nvl2(PO_AUTOCREATE_PARAMS.g_calculate_tax_flag, 'CREATE', NULL) --
1433: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1434: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1435: Similarly for po_distributions_all*/
1436: FROM PO_LINE_LOCATIONS_DRAFT_ALL adv,
1437: PO_LINE_LOCATIONS_DRAFT_ALL deliv,

Line 1434: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used

1430: pod.expenditure_item_date ,
1431: PO_AUTOCREATE_PARAMS.g_sys.sob_id ,
1432: nvl2(PO_AUTOCREATE_PARAMS.g_calculate_tax_flag, 'CREATE', NULL) --
1433: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1434: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1435: Similarly for po_distributions_all*/
1436: FROM PO_LINE_LOCATIONS_DRAFT_ALL adv,
1437: PO_LINE_LOCATIONS_DRAFT_ALL deliv,
1438: po_distributions_draft_all pod

Line 1436: FROM PO_LINE_LOCATIONS_DRAFT_ALL adv,

1432: nvl2(PO_AUTOCREATE_PARAMS.g_calculate_tax_flag, 'CREATE', NULL) --
1433: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1434: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1435: Similarly for po_distributions_all*/
1436: FROM PO_LINE_LOCATIONS_DRAFT_ALL adv,
1437: PO_LINE_LOCATIONS_DRAFT_ALL deliv,
1438: po_distributions_draft_all pod
1439: WHERE adv.po_line_id = p_lines.po_line_id_tbl(i)
1440: AND adv.payment_type = 'ADVANCE'

Line 1437: PO_LINE_LOCATIONS_DRAFT_ALL deliv,

1433: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1434: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1435: Similarly for po_distributions_all*/
1436: FROM PO_LINE_LOCATIONS_DRAFT_ALL adv,
1437: PO_LINE_LOCATIONS_DRAFT_ALL deliv,
1438: po_distributions_draft_all pod
1439: WHERE adv.po_line_id = p_lines.po_line_id_tbl(i)
1440: AND adv.payment_type = 'ADVANCE'
1441: AND deliv.line_location_id =

Line 1443: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll

1439: WHERE adv.po_line_id = p_lines.po_line_id_tbl(i)
1440: AND adv.payment_type = 'ADVANCE'
1441: AND deliv.line_location_id =
1442: (SELECT poll.line_location_id
1443: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll
1444: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1445: AND poll.shipment_type = 'STANDARD'
1446: AND poll.shipment_num =
1447: (SELECT MIN(poll2.shipment_num)

Line 1448: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll2

1444: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1445: AND poll.shipment_type = 'STANDARD'
1446: AND poll.shipment_num =
1447: (SELECT MIN(poll2.shipment_num)
1448: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll2
1449: WHERE poll2.po_line_id = poll.po_line_id
1450: AND poll2.shipment_type = 'STANDARD'
1451: )
1452: )

Line 1467: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated

1463: SELECT poll.line_location_id,
1464: poll.value_basis BULK COLLECT
1465: INTO l_line_loc_id_tbl,
1466: l_line_loc_value_basis_tbl
1467: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1468: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1469: */
1470: FROM po_line_locations_draft_all poll
1471: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i);

Line 1468: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used

1464: poll.value_basis BULK COLLECT
1465: INTO l_line_loc_id_tbl,
1466: l_line_loc_value_basis_tbl
1467: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1468: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1469: */
1470: FROM po_line_locations_draft_all poll
1471: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i);
1472:

Line 1470: FROM po_line_locations_draft_all poll

1466: l_line_loc_value_basis_tbl
1467: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1468: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used
1469: */
1470: FROM po_line_locations_draft_all poll
1471: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i);
1472:
1473: FOR i IN 1..l_line_loc_id_tbl.COUNT
1474: LOOP

Line 1949: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;

1945: l_progress VARCHAR2(3);
1946: l_sum_dist_amounts PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1947: l_last_dist_amount PO_DISTRIBUTIONS_ALL.amount_ordered%TYPE;
1948: l_last_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
1949: l_shipment_amount PO_LINE_LOCATIONS_ALL.amount%TYPE;
1950:
1951: BEGIN
1952:
1953: l_progress:='000';

Line 1979: FROM po_line_locations_draft_all

1975: -- Get the shipment amount ================================================
1976: --
1977: SELECT amount
1978: INTO l_shipment_amount
1979: FROM po_line_locations_draft_all
1980: WHERE line_location_id = p_line_location_id;
1981:
1982: l_progress:='040';
1983: PO_DEBUG.debug_var(l_log_head,l_progress,'l_shipment_amount',l_shipment_amount);

Line 2045: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;

2041: d_progress NUMBER;
2042: l_sum_dist_quantities PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2043: l_last_dist_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
2044: l_last_dist_qty PO_DISTRIBUTIONS_ALL.quantity_ordered%TYPE;
2045: l_shipment_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;
2046:
2047: BEGIN
2048:
2049: d_progress := 0;

Line 2070: FROM po_line_locations_draft_all poll

2066: PO_LOG.stmt(d_module, d_progress, 'l_last_dist_id', l_last_dist_id);
2067: END IF;
2068: SELECT poll.quantity
2069: INTO l_shipment_quantity
2070: FROM po_line_locations_draft_all poll
2071: WHERE poll.line_location_id = p_line_location_id
2072: AND draft_id =po_autocreate_params.g_draft_id;
2073:
2074: d_progress := 30;