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_LINES_ALL

Line 1912: PO_LINES_ALL PL,

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
1916: AND PH.po_header_id = PL.contract_id

Line 1929: PO_LINES_ALL PL,

1925: ( nvl ( PLL.quantity,0) - nvl ( PLL.quantity_cancelled,0 ) )
1926: * nvl(pll.price_override,0) ) , x_precision)), 0)
1927: INTO l_rel_amt_same_curr
1928: FROM PO_LINE_LOCATIONS_ALL PLL,
1929: PO_LINES_ALL PL,
1930: PO_HEADERS_ALL PH,
1931: PO_HEADERS_ALL PH1
1932: WHERE PH.po_header_id = x_object_id
1933: AND PH.po_header_id = PL.contract_id

Line 1949: PO_LINES_ALL PL,

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
1953: AND PH.po_header_id = PL.contract_id

Line 1997: PO_LINES_ALL PL,

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
2000: --,FND_CURRENCIES C
2001: WHERE PH.po_header_id = x_object_id

Line 2016: PO_LINES_ALL PL,

2012: ( nvl ( PLL.quantity,0) - nvl ( PLL.quantity_cancelled,0 ) )
2013: * nvl(pll.price_override,0) )/x_min_unit) * x_min_unit), 0)
2014: INTO l_rel_amt_same_curr
2015: FROM PO_LINE_LOCATIONS_ALL PLL,
2016: PO_LINES_ALL PL,
2017: PO_HEADERS_ALL PH,
2018: PO_HEADERS_ALL PH1
2019: WHERE PH.po_header_id = x_object_id
2020: AND PH.po_header_id = PL.contract_id

Line 2036: PO_LINES_ALL PL,

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
2040: AND PH.po_header_id = PL.contract_id

Line 2267: PO_LINES_ALL POL

2263: INTO x_min_unit,
2264: x_precision
2265: FROM FND_CURRENCIES C,
2266: PO_HEADERS_ALL PH,
2267: PO_LINES_ALL POL
2268: WHERE POL.po_line_id = x_object_id
2269: AND PH.po_header_id = POL.po_header_id
2270: AND C.currency_code = PH.CURRENCY_CODE;
2271:

Line 2697: PO_LINES_ALL POL

2693: INTO l_min_unit,
2694: l_precision
2695: FROM FND_CURRENCIES C,
2696: PO_HEADERS_ALL PH,
2697: PO_LINES_ALL POL
2698: WHERE POL.po_line_id = p_object_id
2699: AND PH.po_header_id = POL.po_header_id
2700: AND C.currency_code = PH.CURRENCY_CODE;
2701:

Line 3016: p_line_id IN PO_LINES_ALL.PO_LINE_ID%TYPE ,

3012:
3013: ===================================================================================*/
3014: FUNCTION GET_RELEASE_LINE_TOTAL
3015: (
3016: p_line_id IN PO_LINES_ALL.PO_LINE_ID%TYPE ,
3017: p_release_id IN PO_RELEASES_ALL.PO_RELEASE_ID%TYPE
3018: )
3019: RETURN NUMBER
3020: IS

Line 3033: PO_LINES_ALL POL

3029: INTO x_min_unit,
3030: x_precision
3031: FROM FND_CURRENCIES C,
3032: PO_HEADERS_ALL PH,
3033: PO_LINES_ALL POL
3034: WHERE POL.po_line_id = p_line_id
3035: AND PH.po_header_id = POL.po_header_id
3036: AND C.currency_code = PH.CURRENCY_CODE;
3037:

Line 3171: po_lines_all pol

3167: / l_base_min_unit )
3168: * l_base_min_unit )
3169: INTO x_total
3170: FROM po_line_locations_all poll,
3171: po_lines_all pol
3172: WHERE poll.po_line_id = pol.po_line_id
3173: AND pol.from_header_id = p_po_header_id
3174: AND Nvl(poll.consigned_flag,'N') <> 'Y';
3175: ELSE -- ( l_po_min_unit IS NULL )

Line 3195: po_lines_all pol

3191: / l_base_min_unit )
3192: * l_base_min_unit )
3193: INTO x_total
3194: FROM po_line_locations_all poll,
3195: po_lines_all pol
3196: WHERE poll.po_line_id = pol.po_line_id
3197: AND pol.from_header_id = p_po_header_id
3198: AND Nvl(poll.consigned_flag,'N') <> 'Y';
3199:

Line 3224: po_lines_all pol

3220: / l_po_min_unit )
3221: * l_po_min_unit )
3222: INTO x_total
3223: FROM po_line_locations_all poll,
3224: po_lines_all pol
3225: WHERE poll.po_line_id = pol.po_line_id
3226: AND pol.from_header_id = p_po_header_id
3227: AND Nvl(poll.consigned_flag,'N') <> 'Y';
3228: ELSE -- ( l_po_min_unit IS NULL )

Line 3246: po_lines_all pol

3242: )
3243: * l_rate )
3244: INTO x_total
3245: FROM po_line_locations_all poll,
3246: po_lines_all pol
3247: WHERE poll.po_line_id = pol.po_line_id
3248: AND pol.from_header_id = p_po_header_id
3249: AND Nvl(poll.consigned_flag,'N') <> 'Y';
3250: END IF;

Line 3275: po_lines_all pol

3271: / l_po_min_unit )
3272: * l_po_min_unit )
3273: INTO x_total
3274: FROM po_line_locations_all poll,
3275: po_lines_all pol
3276: WHERE poll.po_line_id = pol.po_line_id
3277: AND pol.from_header_id = p_po_header_id
3278: AND Nvl(poll.consigned_flag,'N') <> 'Y';
3279:

Line 3297: po_lines_all pol

3293: )
3294: )
3295: INTO x_total
3296: FROM po_line_locations_all poll,
3297: po_lines_all pol
3298: WHERE poll.po_line_id = pol.po_line_id
3299: AND pol.from_header_id = p_po_header_id
3300: AND Nvl(poll.consigned_flag,'N') <> 'Y';
3301:

Line 3326: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,

3322:
3323: ===================================================================================*/
3324: PROCEDURE get_ga_line_amount_released
3325: (
3326: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
3327: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
3328: x_quantity_released OUT NOCOPY NUMBER,
3329: x_amount_released OUT NOCOPY NUMBER
3330: )

Line 3378: po_lines_all pol

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
3381: AND pol.from_line_id = p_po_line_id
3382: AND Nvl(poll.consigned_flag,'N') <> 'Y';

Line 3403: po_lines_all pol

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
3406: AND pol.from_line_id = p_po_line_id
3407: AND Nvl(poll.consigned_flag,'N') <> 'Y';

Line 3545: PO_LINES_ALL POL,

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
3548: AND POL.po_line_id = POLL.po_line_id
3549: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3613: PO_LINES_ALL POL,

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
3616: AND POL.po_line_id = POLL.po_line_id
3617: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3682: PO_LINES_ALL PoL,

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
3685: AND POL.po_line_id = POLL.po_line_id
3686: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3747: PO_LINES_ALL POL,

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
3750: AND POL.po_line_id = POLL.po_line_id
3751: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 3818: PO_LINES_ALL POL,

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
3821: WHERE PH.po_header_id = p_po_header_id
3822: AND PH.po_header_id = POL.contract_id

Line 3887: PO_LINES_ALL POL,

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
3890: WHERE PH.po_header_id = p_po_header_id
3891: AND PH.po_header_id = POL.contract_id --

Line 4233: FROM PO_LINES_ALL POL

4229: UPDATE PO_SESSION_GT
4230: SET num2 =
4231: (
4232: SELECT POL.po_header_id
4233: FROM PO_LINES_ALL POL
4234: WHERE POL.po_line_id = p_doc_level_id_tbl(i)
4235: )
4236: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4237: RETURNING num2

Line 4504: PO_LINES_MERGE_V POL -- replaced PO_LINES_ALL

4500:
4501: SELECT POL.po_line_id
4502: BULK COLLECT INTO x_line_id_tbl
4503: FROM
4504: PO_LINES_MERGE_V POL -- replaced PO_LINES_ALL
4505: , PO_SESSION_GT IDS
4506: WHERE POL.po_header_id = IDS.num1
4507: AND POL.draft_id = p_draft_id
4508: AND IDS.key = l_id_key

Line 8034: line_last_update_date PO_LINES_ALL.last_update_date%type;

8030: -------------------------------------------------------------------------------
8031: FUNCTION get_last_update_date_for_doc(p_doc_header_id IN NUMBER) RETURN DATE
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

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

8048: END IF;
8049: d_pos := 10;
8050: select nvl(max(last_update_date), min_date) into header_last_update_date from po_headers_all where po_header_id = p_doc_header_id;
8051: d_pos := 20;
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;