APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_ALL

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 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 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 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 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 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 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;