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_CORE_S dependencies on PO_DISTRIBUTIONS_ALL

Line 1266: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1262: )
1263: , X_precision) ,
1264: X_base_precision)),0)
1265: INTO X_result_fld
1266: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1267: WHERE PLL.po_header_id = X_object_id
1268: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1269: AND PLL.line_location_id = POD.line_location_id;
1270:

Line 1294: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1290: * POD.rate / X_min_unit
1291: )
1292: * X_min_unit , X_base_precision)),0)
1293: INTO X_result_fld
1294: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1295: WHERE PLL.po_header_id = X_object_id
1296: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1297: AND PLL.line_location_id = POD.line_location_id;
1298:

Line 1324: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1320: )
1321: * POD.rate , X_precision)
1322: / X_base_min_unit ) * X_base_min_unit) ,0)
1323: INTO X_result_fld
1324: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1325: WHERE PLL.po_header_id = X_object_id
1326: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1327: AND PLL.line_location_id = POD.line_location_id;
1328:

Line 1351: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1347: * POD.rate /
1348: X_min_unit) * X_min_unit / X_base_min_unit)
1349: * X_base_min_unit) , 0)
1350: INTO X_result_fld
1351: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1352: WHERE PLL.po_header_id = X_object_id
1353: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1354: AND PLL.line_location_id = POD.line_location_id;
1355:

Line 1518: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1514: nvl(POD.quantity_cancelled, 0)) *
1515: nvl(PLL.price_override, 0) * POD.rate, X_precision) ,
1516: X_base_precision)),0)
1517: INTO X_result_fld
1518: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1519: WHERE PLL.po_header_id = X_object_id
1520: -- Bugs 482497 and 602664, lpo, 12/22/97
1521: AND PLL.shipment_type = 'SCHEDULED'
1522: -- End of fix. Bugs 482497 and 602664, lpo, 12/22/97

Line 1533: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1529: nvl(POD.quantity_cancelled, 0)) *
1530: nvl(PLL.price_override, 0) * POD.rate /
1531: X_min_unit) * X_min_unit , X_base_precision)),0)
1532: INTO X_result_fld
1533: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1534: WHERE PLL.po_header_id = X_object_id
1535: -- Bugs 482497 and 602664, lpo, 12/22/97
1536: AND PLL.shipment_type = 'SCHEDULED'
1537: -- End of fix. Bugs 482497 and 602664, lpo, 12/22/97

Line 1551: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1547: nvl(POD.quantity_cancelled, 0)) *
1548: nvl(PLL.price_override, 0) * POD.rate , X_precision)
1549: / X_base_min_unit ) * X_base_min_unit) ,0)
1550: INTO X_result_fld
1551: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1552: WHERE PLL.po_header_id = X_object_id
1553: -- Bugs 482497 and 602664, lpo, 12/22/97
1554: AND PLL.shipment_type = 'SCHEDULED'
1555: -- End of fix. Bugs 482497 and 602664, lpo, 12/22/97

Line 1567: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1563: nvl(PLL.price_override, 0) * POD.rate /
1564: X_min_unit) * X_min_unit / X_base_min_unit)
1565: * X_base_min_unit) , 0)
1566: INTO X_result_fld
1567: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1568: WHERE PLL.po_header_id = X_object_id
1569: -- Bugs 482497 and 602664, lpo, 12/22/97
1570: AND PLL.shipment_type = 'SCHEDULED'
1571: -- End of fix. Bugs 482497 and 602664, lpo, 12/22/97

Line 1879: quantity/amount from po_distributions_all;

1875: /*Bug 12723347
1876: 1)For execution documents with same currency as the Contract, get
1877: quantity/amount from po_line_locations_all;
1878: 2)For execution documents with different currency as the Contract, get
1879: quantity/amount from po_distributions_all;
1880:
1881: Assume most execution documents have same currency as the contract, so the
1882: performance impact as described in bug 7518629 by reverting back to POD
1883: (second case) will be limited.*/

Line 1911: PO_DISTRIBUTIONS_ALL POD,

1907: * nvl(pll.price_override,0) ) * nvl(POD.rate,nvl(PH1.rate,1)) / nvl (PH.rate,1),x_precision)
1908: ) ) , 0 )
1909: INTO x_result_fld
1910: FROM PO_LINE_LOCATIONS_ALL PLL,
1911: PO_DISTRIBUTIONS_ALL POD,
1912: PO_LINES_ALL PL,
1913: PO_HEADERS_ALL PH,
1914: PO_HEADERS_ALL PH1
1915: WHERE PH.po_header_id = x_object_id

Line 1948: PO_DISTRIBUTIONS_ALL POD,

1944: /nvl(PH.rate,1)), x_precision)
1945: ),0)
1946: INTO l_rel_amt_diff_curr
1947: FROM PO_LINE_LOCATIONS_ALL PLL,
1948: PO_DISTRIBUTIONS_ALL POD,
1949: PO_LINES_ALL PL,
1950: PO_HEADERS_ALL PH,
1951: PO_HEADERS_ALL PH1
1952: WHERE PH.po_header_id = x_object_id

Line 1995: FROM PO_DISTRIBUTIONS_ALL POD,

1991: * nvl(pll.price_override,0)))
1992: * nvl(POD.rate, nvl(PH1.rate,1))/nvl(PH.rate,1)/x_min_unit))
1993: * x_min_unit),0)
1994: INTO x_result_fld
1995: FROM PO_DISTRIBUTIONS_ALL POD,
1996: PO_LINE_LOCATIONS_ALL PLL,
1997: PO_LINES_ALL PL,
1998: PO_HEADERS_ALL PH,
1999: PO_HEADERS_ALL PH1

Line 2035: PO_DISTRIBUTIONS_ALL POD,

2031: /nvl(PH.rate,1))/x_min_unit)
2032: * x_min_unit),0)
2033: INTO l_rel_amt_diff_curr
2034: FROM PO_LINE_LOCATIONS_ALL PLL,
2035: PO_DISTRIBUTIONS_ALL POD,
2036: PO_LINES_ALL PL,
2037: PO_HEADERS_ALL PH,
2038: PO_HEADERS_ALL PH1
2039: WHERE PH.po_header_id = x_object_id

Line 2108: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

2104: )
2105: * POD.rate
2106: ,x_precision),x_base_precision)),0)
2107: INTO x_result_fld
2108: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
2109: WHERE PLL.po_release_id = x_object_id
2110: AND PLL.line_location_id = POD.line_location_id
2111: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2112:

Line 2130: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

2126: )
2127: * POD.rate /
2128: X_min_unit) * X_min_unit , X_base_precision)),0)
2129: INTO x_result_fld
2130: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
2131: WHERE PLL.po_release_id = x_object_id
2132: AND PLL.line_location_id = POD.line_location_id
2133: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2134:

Line 2155: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

2151: * POD.rate
2152: , X_precision)
2153: / X_base_min_unit ) * X_base_min_unit) ,0)
2154: INTO X_result_fld
2155: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
2156: WHERE PLL.po_release_id = x_object_id
2157: AND PLL.line_location_id = POD.line_location_id
2158: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2159:

Line 2178: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

2174: * POD.rate /
2175: X_min_unit) * X_min_unit / X_base_min_unit)
2176: * X_base_min_unit) , 0)
2177: INTO X_result_fld
2178: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
2179: WHERE PLL.po_release_id = x_object_id
2180: AND PLL.line_location_id = POD.line_location_id
2181: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2182:

Line 3376: FROM po_distributions_all pod,

3372: * l_po_min_unit ),
3373: sum ( pod.quantity_ordered - pod.quantity_cancelled )
3374: INTO x_amount_released,
3375: x_quantity_released
3376: FROM po_distributions_all pod,
3377: po_line_locations_all poll,
3378: po_lines_all pol
3379: WHERE pod.line_location_id = poll.line_location_id
3380: AND poll.po_line_id = pol.po_line_id

Line 3401: FROM po_distributions_all pod,

3397: ),
3398: sum ( pod.quantity_ordered - pod.quantity_cancelled )
3399: INTO x_amount_released,
3400: x_quantity_released
3401: FROM po_distributions_all pod,
3402: po_line_locations_all poll,
3403: po_lines_all pol
3404: WHERE pod.line_location_id = poll.line_location_id
3405: AND poll.po_line_id = pol.po_line_id

Line 3543: FROM PO_DISTRIBUTIONS_ALL POD,

3539: )
3540: )
3541: ,0)
3542: INTO l_total
3543: FROM PO_DISTRIBUTIONS_ALL POD,
3544: PO_LINE_LOCATIONS_ALL POLL,
3545: PO_LINES_ALL POL,
3546: PO_HEADERS_ALL PH1
3547: WHERE POL.contract_id = p_po_header_id

Line 3611: FROM PO_DISTRIBUTIONS_ALL POD,

3607: )
3608: )
3609: ,0)
3610: INTO l_total
3611: FROM PO_DISTRIBUTIONS_ALL POD,
3612: PO_LINE_LOCATIONS_ALL POLL,
3613: PO_LINES_ALL POL,
3614: PO_HEADERS_ALL PH1
3615: WHERE POL.contract_id = p_po_header_id

Line 3680: FROM PO_DISTRIBUTIONS_ALL POD,

3676: , l_base_precision)
3677: )
3678: ),0)
3679: INTO l_total
3680: FROM PO_DISTRIBUTIONS_ALL POD,
3681: PO_LINE_LOCATIONS_ALL POLL,
3682: PO_LINES_ALL PoL,
3683: PO_HEADERS_ALL PH1
3684: WHERE POL.contract_id = p_po_header_id

Line 3745: FROM PO_DISTRIBUTIONS_ALL POD,

3741: , l_base_precision)
3742: )
3743: ),0)
3744: INTO l_total
3745: FROM PO_DISTRIBUTIONS_ALL POD,
3746: PO_LINE_LOCATIONS_ALL POLL,
3747: PO_LINES_ALL POL,
3748: PO_HEADERS_ALL PH1
3749: WHERE POL.contract_id = p_po_header_id

Line 3816: FROM PO_DISTRIBUTIONS_ALL POD,

3812: )
3813: )
3814: ,0)
3815: INTO l_total
3816: FROM PO_DISTRIBUTIONS_ALL POD,
3817: PO_LINE_LOCATIONS_ALL POLL,
3818: PO_LINES_ALL POL,
3819: PO_HEADERS_ALL PH,
3820: PO_HEADERS_ALL PH1

Line 3885: FROM PO_DISTRIBUTIONS_ALL POD,

3881: )
3882: )
3883: ,0)
3884: INTO l_total
3885: FROM PO_DISTRIBUTIONS_ALL POD,
3886: PO_LINE_LOCATIONS_ALL POLL,
3887: PO_LINES_ALL POL,
3888: PO_HEADERS_ALL PH,
3889: PO_HEADERS_ALL PH1

Line 4311: FROM PO_DISTRIBUTIONS_ALL POD

4307: SELECT DECODE( p_doc_type
4308: , g_doc_type_RELEASE, POD.po_release_id
4309: , POD.po_header_id
4310: )
4311: FROM PO_DISTRIBUTIONS_ALL POD
4312: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4313: )
4314: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4315: RETURNING num2

Line 4658: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

4654: UPDATE PO_SESSION_GT
4655: SET num2 =
4656: (
4657: SELECT POD.po_line_id
4658: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
4659: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4660: AND POD.draft_id = p_draft_id
4661: )
4662: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))

Line 4927: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

4923: UPDATE PO_SESSION_GT
4924: SET num2 =
4925: (
4926: SELECT POD.line_location_id
4927: FROM PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
4928: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4929: AND POD.draft_id = p_draft_id
4930: )
4931: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))

Line 5164: PO_DISTRIBUTIONS_ALL POD

5160:
5161: SELECT POD.po_distribution_id
5162: BULK COLLECT INTO x_distribution_id_tbl
5163: FROM
5164: PO_DISTRIBUTIONS_ALL POD
5165: , PO_SESSION_GT IDS
5166: WHERE POD.po_release_id = IDS.num1
5167: AND IDS.key = l_doc_level_id_key
5168: ;

Line 5182: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

5178:
5179: SELECT POD.po_distribution_id
5180: BULK COLLECT INTO x_distribution_id_tbl
5181: FROM
5182: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5183: , PO_SESSION_GT IDS
5184: WHERE POD.po_header_id = IDS.num1
5185: AND POD.draft_id = p_draft_id
5186: AND POD.po_release_id IS NULL

Line 5204: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

5200:
5201: SELECT POD.po_distribution_id
5202: BULK COLLECT INTO x_distribution_id_tbl
5203: FROM
5204: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5205: , PO_SESSION_GT IDS
5206: WHERE POD.po_line_id = IDS.num1
5207: AND POD.draft_id = p_draft_id
5208: AND POD.po_release_id IS NULL

Line 5226: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL

5222:
5223: SELECT POD.po_distribution_id
5224: BULK COLLECT INTO x_distribution_id_tbl
5225: FROM
5226: PO_DISTRIBUTIONS_MERGE_V POD -- replaced PO_DISTRIBUTIONS_ALL
5227: , PO_SESSION_GT IDS
5228: WHERE POD.line_location_id = IDS.num1
5229: AND POD.draft_id = p_draft_id
5230: AND IDS.key = l_doc_level_id_key

Line 6617: PO_DISTRIBUTIONS_ALL POD

6613: , x_unreserved_count
6614: , x_prevented_count
6615:
6616: FROM
6617: PO_DISTRIBUTIONS_ALL POD
6618: , PO_LINE_LOCATIONS_ALL POLL
6619: , PO_HEADERS_ALL POH
6620:
6621: WHERE POLL.line_location_id(+) = POD.line_location_id

Line 8036: dist_last_update_date PO_DISTRIBUTIONS_ALL.last_update_date%type;

8032: IS
8033: header_last_update_date PO_HEADERS_ALL.last_update_date%type;
8034: line_last_update_date PO_LINES_ALL.last_update_date%type;
8035: line_loc_last_update_date PO_LINE_LOCATIONS_ALL.last_update_date%type;
8036: dist_last_update_date PO_DISTRIBUTIONS_ALL.last_update_date%type;
8037: doc_last_update_date PO_HEADERS_ALL.last_update_date%type;
8038: --Lowest date supported by database as we need to handle null dates
8039: min_date PO_HEADERS_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');
8040:

Line 8056: select nvl(max(last_update_date), min_date) into dist_last_update_date from po_distributions_all where po_header_id = p_doc_header_id;

8052: select nvl(max(last_update_date), min_date) into line_last_update_date from po_lines_all where po_header_id = p_doc_header_id;
8053: d_pos := 30;
8054: select nvl(max(last_update_date), min_date) into line_loc_last_update_date from po_line_locations_all where po_header_id = p_doc_header_id;
8055: d_pos := 40;
8056: select nvl(max(last_update_date), min_date) into dist_last_update_date from po_distributions_all where po_header_id = p_doc_header_id;
8057: d_pos := 50;
8058: doc_last_update_date := greatest( header_last_update_date
8059: ,line_last_update_date
8060: ,line_loc_last_update_date