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 1255: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1251: )
1252: , X_precision) ,
1253: X_base_precision)),0)
1254: INTO X_result_fld
1255: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1256: WHERE PLL.po_header_id = X_object_id
1257: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1258: AND PLL.line_location_id = POD.line_location_id;
1259:

Line 1282: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1278: * POD.rate / X_min_unit
1279: )
1280: * X_min_unit , X_base_precision)),0)
1281: INTO X_result_fld
1282: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1283: WHERE PLL.po_header_id = X_object_id
1284: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1285: AND PLL.line_location_id = POD.line_location_id;
1286:

Line 1311: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1307: )
1308: * POD.rate , X_precision)
1309: / X_base_min_unit ) * X_base_min_unit) ,0)
1310: INTO X_result_fld
1311: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1312: WHERE PLL.po_header_id = X_object_id
1313: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1314: AND PLL.line_location_id = POD.line_location_id;
1315:

Line 1337: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1333: * POD.rate /
1334: X_min_unit) * X_min_unit / X_base_min_unit)
1335: * X_base_min_unit) , 0)
1336: INTO X_result_fld
1337: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1338: WHERE PLL.po_header_id = X_object_id
1339: AND PLL.shipment_type in ('STANDARD','PLANNED','BLANKET')
1340: AND PLL.line_location_id = POD.line_location_id;
1341:

Line 1503: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1499: nvl(POD.quantity_cancelled, 0)) *
1500: nvl(PLL.price_override, 0) * POD.rate, X_precision) ,
1501: X_base_precision)),0)
1502: INTO X_result_fld
1503: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1504: WHERE PLL.po_header_id = X_object_id
1505: -- Bugs 482497 and 602664, lpo, 12/22/97
1506: AND PLL.shipment_type = 'SCHEDULED'
1507: -- End of fix. Bugs 482497 and 602664, lpo, 12/22/97

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 /
1516: X_min_unit) * X_min_unit , 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 1536: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

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

Line 1552: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

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

Line 1870: FROM PO_DISTRIBUTIONS_ALL POD,

1866: * nvl(pll.price_override,0)
1867: * nvl(POD.rate, nvl(PH1.rate,1))/nvl(PH.rate,1),x_precision)
1868: )),0)
1869: INTO x_result_fld
1870: FROM PO_DISTRIBUTIONS_ALL POD,
1871: PO_LINE_LOCATIONS_ALL PLL,
1872: PO_LINES_ALL PL,
1873: PO_HEADERS_ALL PH,
1874: PO_HEADERS_ALL PH1

Line 1904: FROM PO_DISTRIBUTIONS_ALL POD,

1900: * nvl(pll.price_override,0)
1901: * nvl(POD.rate, nvl(PH1.rate,1))/nvl(PH.rate,1)/x_min_unit))
1902: * x_min_unit),0)
1903: INTO x_result_fld
1904: FROM PO_DISTRIBUTIONS_ALL POD,
1905: PO_LINE_LOCATIONS_ALL PLL,
1906: PO_LINES_ALL PL,
1907: PO_HEADERS_ALL PH,
1908: PO_HEADERS_ALL PH1

Line 1976: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1972: )
1973: * POD.rate
1974: ,x_precision),x_base_precision)),0)
1975: INTO x_result_fld
1976: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1977: WHERE PLL.po_release_id = x_object_id
1978: AND PLL.line_location_id = POD.line_location_id
1979: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
1980:

Line 1998: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

1994: )
1995: * POD.rate /
1996: X_min_unit) * X_min_unit , X_base_precision)),0)
1997: INTO x_result_fld
1998: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
1999: WHERE PLL.po_release_id = x_object_id
2000: AND PLL.line_location_id = POD.line_location_id
2001: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2002:

Line 2023: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

2019: * POD.rate
2020: , X_precision)
2021: / X_base_min_unit ) * X_base_min_unit) ,0)
2022: INTO X_result_fld
2023: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
2024: WHERE PLL.po_release_id = x_object_id
2025: AND PLL.line_location_id = POD.line_location_id
2026: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2027:

Line 2046: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL

2042: * POD.rate /
2043: X_min_unit) * X_min_unit / X_base_min_unit)
2044: * X_base_min_unit) , 0)
2045: INTO X_result_fld
2046: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL PLL
2047: WHERE PLL.po_release_id = x_object_id
2048: AND PLL.line_location_id = POD.line_location_id
2049: AND PLL.shipment_type in ('SCHEDULED','BLANKET');
2050:

Line 3037: FROM po_distributions_all pod,

3033: * l_po_min_unit )
3034: / l_base_min_unit )
3035: * l_base_min_unit )
3036: INTO x_total
3037: FROM po_distributions_all pod,
3038: po_line_locations_all poll,
3039: po_lines_all pol
3040: WHERE pod.line_location_id = poll.line_location_id
3041: AND poll.po_line_id = pol.po_line_id

Line 3062: FROM po_distributions_all pod,

3058: * l_rate )
3059: / l_base_min_unit )
3060: * l_base_min_unit )
3061: INTO x_total
3062: FROM po_distributions_all pod,
3063: po_line_locations_all poll,
3064: po_lines_all pol
3065: WHERE pod.line_location_id = poll.line_location_id
3066: AND poll.po_line_id = pol.po_line_id

Line 3091: FROM po_distributions_all pod,

3087: * l_rate )
3088: / l_po_min_unit )
3089: * l_po_min_unit )
3090: INTO x_total
3091: FROM po_distributions_all pod,
3092: po_line_locations_all poll,
3093: po_lines_all pol
3094: WHERE pod.line_location_id = poll.line_location_id
3095: AND poll.po_line_id = pol.po_line_id

Line 3114: FROM po_distributions_all pod,

3110: )
3111: )
3112: * l_rate )
3113: INTO x_total
3114: FROM po_distributions_all pod,
3115: po_line_locations_all poll,
3116: po_lines_all pol
3117: WHERE pod.line_location_id = poll.line_location_id
3118: AND poll.po_line_id = pol.po_line_id

Line 3144: FROM po_distributions_all pod,

3140: )
3141: / l_po_min_unit )
3142: * l_po_min_unit )
3143: INTO x_total
3144: FROM po_distributions_all pod,
3145: po_line_locations_all poll,
3146: po_lines_all pol
3147: WHERE pod.line_location_id = poll.line_location_id
3148: AND poll.po_line_id = pol.po_line_id

Line 3166: FROM po_distributions_all pod,

3162: * poll.price_override)
3163: )
3164: )
3165: INTO x_total
3166: FROM po_distributions_all pod,
3167: po_line_locations_all poll,
3168: po_lines_all pol
3169: WHERE pod.line_location_id = poll.line_location_id
3170: AND poll.po_line_id = pol.po_line_id

Line 3244: FROM po_distributions_all pod,

3240: * l_po_min_unit ),
3241: sum ( pod.quantity_ordered - pod.quantity_cancelled )
3242: INTO x_amount_released,
3243: x_quantity_released
3244: FROM po_distributions_all pod,
3245: po_line_locations_all poll,
3246: po_lines_all pol
3247: WHERE pod.line_location_id = poll.line_location_id
3248: AND poll.po_line_id = pol.po_line_id

Line 3268: FROM po_distributions_all pod,

3264: ),
3265: sum ( pod.quantity_ordered - pod.quantity_cancelled )
3266: INTO x_amount_released,
3267: x_quantity_released
3268: FROM po_distributions_all pod,
3269: po_line_locations_all poll,
3270: po_lines_all pol
3271: WHERE pod.line_location_id = poll.line_location_id
3272: AND poll.po_line_id = pol.po_line_id

Line 3406: FROM PO_DISTRIBUTIONS_ALL POD,

3402: )
3403: )
3404: ,0)
3405: INTO l_total
3406: FROM PO_DISTRIBUTIONS_ALL POD,
3407: PO_LINE_LOCATIONS_ALL POLL,
3408: PO_LINES_ALL POL,
3409: PO_HEADERS_ALL PH1
3410: WHERE POL.contract_id = p_po_header_id

Line 3472: FROM PO_DISTRIBUTIONS_ALL POD,

3468: )
3469: )
3470: ,0)
3471: INTO l_total
3472: FROM PO_DISTRIBUTIONS_ALL POD,
3473: PO_LINE_LOCATIONS_ALL POLL,
3474: PO_LINES_ALL POL,
3475: PO_HEADERS_ALL PH1
3476: WHERE POL.contract_id = p_po_header_id

Line 3539: FROM PO_DISTRIBUTIONS_ALL POD,

3535: , l_base_precision)
3536: )
3537: ),0)
3538: INTO l_total
3539: FROM PO_DISTRIBUTIONS_ALL POD,
3540: PO_LINE_LOCATIONS_ALL POLL,
3541: PO_LINES_ALL PoL,
3542: PO_HEADERS_ALL PH1
3543: WHERE POL.contract_id = p_po_header_id

Line 3602: FROM PO_DISTRIBUTIONS_ALL POD,

3598: , l_base_precision)
3599: )
3600: ),0)
3601: INTO l_total
3602: FROM PO_DISTRIBUTIONS_ALL POD,
3603: PO_LINE_LOCATIONS_ALL POLL,
3604: PO_LINES_ALL POL,
3605: PO_HEADERS_ALL PH1
3606: WHERE POL.contract_id = p_po_header_id

Line 3670: FROM PO_DISTRIBUTIONS_ALL POD,

3666: )
3667: )
3668: ,0)
3669: INTO l_total
3670: FROM PO_DISTRIBUTIONS_ALL POD,
3671: PO_LINE_LOCATIONS_ALL POLL,
3672: PO_LINES_ALL POL,
3673: PO_HEADERS_ALL PH,
3674: PO_HEADERS_ALL PH1

Line 3737: FROM PO_DISTRIBUTIONS_ALL POD,

3733: )
3734: )
3735: ,0)
3736: INTO l_total
3737: FROM PO_DISTRIBUTIONS_ALL POD,
3738: PO_LINE_LOCATIONS_ALL POLL,
3739: PO_LINES_ALL POL,
3740: PO_HEADERS_ALL PH,
3741: PO_HEADERS_ALL PH1

Line 4161: FROM PO_DISTRIBUTIONS_ALL POD

4157: SELECT DECODE( p_doc_type
4158: , g_doc_type_RELEASE, POD.po_release_id
4159: , POD.po_header_id
4160: )
4161: FROM PO_DISTRIBUTIONS_ALL POD
4162: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4163: )
4164: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4165: RETURNING num2

Line 4490: FROM PO_DISTRIBUTIONS_ALL POD

4486: UPDATE PO_SESSION_GT
4487: SET num2 =
4488: (
4489: SELECT POD.po_line_id
4490: FROM PO_DISTRIBUTIONS_ALL POD
4491: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4492: )
4493: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4494: RETURNING num2

Line 4739: FROM PO_DISTRIBUTIONS_ALL POD

4735: UPDATE PO_SESSION_GT
4736: SET num2 =
4737: (
4738: SELECT POD.line_location_id
4739: FROM PO_DISTRIBUTIONS_ALL POD
4740: WHERE POD.po_distribution_id = p_doc_level_id_tbl(i)
4741: )
4742: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4743: RETURNING num2

Line 4959: PO_DISTRIBUTIONS_ALL POD

4955:
4956: SELECT POD.po_distribution_id
4957: BULK COLLECT INTO x_distribution_id_tbl
4958: FROM
4959: PO_DISTRIBUTIONS_ALL POD
4960: , PO_SESSION_GT IDS
4961: WHERE POD.po_release_id = IDS.num1
4962: AND IDS.key = l_doc_level_id_key
4963: ;

Line 4977: PO_DISTRIBUTIONS_ALL POD

4973:
4974: SELECT POD.po_distribution_id
4975: BULK COLLECT INTO x_distribution_id_tbl
4976: FROM
4977: PO_DISTRIBUTIONS_ALL POD
4978: , PO_SESSION_GT IDS
4979: WHERE POD.po_header_id = IDS.num1
4980: AND POD.po_release_id IS NULL
4981: -- Don't pick up Release distributions when acting on a PPO/BPA/GA.

Line 4998: PO_DISTRIBUTIONS_ALL POD

4994:
4995: SELECT POD.po_distribution_id
4996: BULK COLLECT INTO x_distribution_id_tbl
4997: FROM
4998: PO_DISTRIBUTIONS_ALL POD
4999: , PO_SESSION_GT IDS
5000: WHERE POD.po_line_id = IDS.num1
5001: AND POD.po_release_id IS NULL
5002: -- Don't pick up SR distributions when acting on a PPO.

Line 5019: PO_DISTRIBUTIONS_ALL POD

5015:
5016: SELECT POD.po_distribution_id
5017: BULK COLLECT INTO x_distribution_id_tbl
5018: FROM
5019: PO_DISTRIBUTIONS_ALL POD
5020: , PO_SESSION_GT IDS
5021: WHERE POD.line_location_id = IDS.num1
5022: AND IDS.key = l_doc_level_id_key
5023: ;

Line 6409: PO_DISTRIBUTIONS_ALL POD

6405: , x_unreserved_count
6406: , x_prevented_count
6407:
6408: FROM
6409: PO_DISTRIBUTIONS_ALL POD
6410: , PO_LINE_LOCATIONS_ALL POLL
6411: , PO_HEADERS_ALL POH
6412:
6413: WHERE POLL.line_location_id(+) = POD.line_location_id

Line 7828: dist_last_update_date PO_DISTRIBUTIONS_ALL.last_update_date%type;

7824: IS
7825: header_last_update_date PO_HEADERS_ALL.last_update_date%type;
7826: line_last_update_date PO_LINES_ALL.last_update_date%type;
7827: line_loc_last_update_date PO_LINE_LOCATIONS_ALL.last_update_date%type;
7828: dist_last_update_date PO_DISTRIBUTIONS_ALL.last_update_date%type;
7829: doc_last_update_date PO_HEADERS_ALL.last_update_date%type;
7830: --Lowest date supported by database as we need to handle null dates
7831: min_date PO_HEADERS_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');
7832:

Line 7848: 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;

7844: 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;
7845: d_pos := 30;
7846: 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;
7847: d_pos := 40;
7848: 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;
7849: d_pos := 50;
7850: doc_last_update_date := greatest( header_last_update_date
7851: ,line_last_update_date
7852: ,line_loc_last_update_date