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_HEADERS_ALL

Line 1384: PO_HEADERS_ALL PH

1380: c.precision
1381: INTO x_min_unit,
1382: x_precision
1383: FROM FND_CURRENCIES C,
1384: PO_HEADERS_ALL PH
1385: WHERE PH.po_header_id = x_object_id
1386: AND C.currency_code = PH.CURRENCY_CODE;
1387:
1388: if x_min_unit is null then

Line 1591: PO_HEADERS_ALL PH

1587: c.precision
1588: INTO x_min_unit,
1589: x_precision
1590: FROM FND_CURRENCIES C,
1591: PO_HEADERS_ALL PH
1592: WHERE PH.po_header_id = x_object_id
1593: AND C.currency_code = PH.CURRENCY_CODE;
1594:
1595: /* 958792 kbenjami 8/25/99. Proprogated fix from R11.

Line 1846: PO_HEADERS_ALL PH

1842: c.precision
1843: INTO x_min_unit,
1844: x_precision
1845: FROM FND_CURRENCIES C,
1846: PO_HEADERS_ALL PH
1847: WHERE PH.po_header_id = x_object_id
1848: AND C.currency_code = PH.CURRENCY_CODE;
1849:
1850: /* 716188 - SVAIDYAN : Changed the sql stmt to select only Standard and Planned

Line 1913: PO_HEADERS_ALL PH,

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
1917: AND PL.po_line_id = PLL.po_line_id

Line 1914: PO_HEADERS_ALL PH1

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
1917: AND PL.po_line_id = PLL.po_line_id
1918: AND PLL.shipment_type IN ('STANDARD','PLANNED')

Line 1930: PO_HEADERS_ALL PH,

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
1934: AND PL.po_line_id = PLL.po_line_id

Line 1931: PO_HEADERS_ALL PH1

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
1934: AND PL.po_line_id = PLL.po_line_id
1935: AND PLL.shipment_type IN ('STANDARD','PLANNED')

Line 1950: PO_HEADERS_ALL PH,

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
1954: AND PL.po_line_id = PLL.po_line_id

Line 1951: PO_HEADERS_ALL PH1

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
1954: AND PL.po_line_id = PLL.po_line_id
1955: AND PLL.shipment_type IN ('STANDARD','PLANNED')

Line 1998: PO_HEADERS_ALL PH,

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

Line 1999: PO_HEADERS_ALL PH1

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
2002: AND PH.po_header_id = PL.contract_id --
2003: --AND PH.currency_code = C.currency_code

Line 2017: PO_HEADERS_ALL PH,

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
2021: AND PL.po_line_id = PLL.po_line_id

Line 2018: PO_HEADERS_ALL PH1

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
2021: AND PL.po_line_id = PLL.po_line_id
2022: AND PLL.shipment_type IN ('STANDARD','PLANNED')

Line 2037: PO_HEADERS_ALL PH,

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
2041: AND PL.po_line_id = PLL.po_line_id

Line 2038: PO_HEADERS_ALL PH1

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
2041: AND PL.po_line_id = PLL.po_line_id
2042: AND PLL.shipment_type IN ('STANDARD','PLANNED')

Line 2061: FROM PO_HEADERS_ALL POH,

2057: SELECT GSB.currency_code,
2058: POH.currency_code
2059: INTO x_base_currency,
2060: x_po_currency
2061: FROM PO_HEADERS_ALL POH,
2062: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2063: GL_SETS_OF_BOOKS GSB,
2064: PO_RELEASES_ALL POR
2065: WHERE POR.po_release_id = x_object_id

Line 2196: PO_HEADERS_ALL PH

2192: INTO x_min_unit,
2193: x_precision
2194: FROM FND_CURRENCIES C,
2195: PO_RELEASES_ALL POR,
2196: PO_HEADERS_ALL PH
2197: WHERE POR.po_release_id = x_object_id
2198: AND PH.po_header_id = POR.PO_HEADER_ID
2199: AND C.currency_code = PH.CURRENCY_CODE;
2200:

Line 2266: PO_HEADERS_ALL PH,

2262: sum(c.precision)
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;

Line 2333: PO_HEADERS_ALL PH,

2329: c.precision
2330: INTO x_min_unit,
2331: x_precision
2332: FROM FND_CURRENCIES C,
2333: PO_HEADERS_ALL PH,
2334: PO_LINE_LOCATIONS_ALL PLL
2335: WHERE PLL.line_location_id = x_object_id
2336: AND PH.po_header_id = PLL.po_header_id
2337: AND C.currency_code = PH.CURRENCY_CODE;

Line 2435: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2431: p_doc_type IN VARCHAR2,
2432: p_doc_subtype IN VARCHAR2,
2433: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2434:
2435: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2439: l_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2432: p_doc_subtype IN VARCHAR2,
2433: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2434:
2435: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2436: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2437: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2438: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2439: l_precision FND_CURRENCIES.PRECISION%TYPE;
2440: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2542: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2538: p_doc_subtype IN VARCHAR2,
2539: p_doc_revision IN NUMBER,
2540: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2541:
2542: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2546: l_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2539: p_doc_revision IN NUMBER,
2540: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2541:
2542: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2543: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2544: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2545: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2546: l_precision FND_CURRENCIES.PRECISION%TYPE;
2547: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2634: PO_HEADERS_ALL PH,

2630: c.precision
2631: INTO l_min_unit,
2632: l_precision
2633: FROM FND_CURRENCIES C,
2634: PO_HEADERS_ALL PH,
2635: PO_LINE_LOCATIONS_ALL PLL
2636: WHERE PLL.line_location_id = p_object_id
2637: AND PH.po_header_id = PLL.po_header_id
2638: AND C.currency_code = PH.CURRENCY_CODE;

Line 2696: PO_HEADERS_ALL PH,

2692: sum(c.precision)
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;

Line 2764: FROM PO_HEADERS_ALL POH,

2760: SELECT GSB.currency_code,
2761: POH.currency_code
2762: INTO l_base_currency,
2763: l_po_currency
2764: FROM PO_HEADERS_ALL POH,
2765: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2766: GL_SETS_OF_BOOKS GSB,
2767: PO_RELEASES_ALL POR
2768: WHERE POR.po_release_id = p_object_id

Line 2914: PO_HEADERS_ALL PH

2910: INTO l_min_unit,
2911: l_precision
2912: FROM FND_CURRENCIES C,
2913: PO_RELEASES_ALL POR,
2914: PO_HEADERS_ALL PH
2915: WHERE POR.po_release_id = p_object_id
2916: AND PH.po_header_id = POR.PO_HEADER_ID
2917: AND C.currency_code = PH.CURRENCY_CODE;
2918:

Line 3032: PO_HEADERS_ALL PH,

3028: sum(c.precision)
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;

Line 3093: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE,

3089:
3090: ===================================================================================*/
3091: FUNCTION get_ga_amount_released
3092: (
3093: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE,
3094: p_convert_to_base BOOLEAN := FALSE
3095: )
3096: RETURN NUMBER
3097: IS

Line 3108: l_rate PO_HEADERS_ALL.rate%TYPE;

3104: l_po_precision FND_CURRENCIES.precision%TYPE;
3105: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3106: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3107:
3108: l_rate PO_HEADERS_ALL.rate%TYPE;
3109:
3110: x_total NUMBER;
3111:
3112: BEGIN

Line 3141: -- Get the rate from PO_HEADERS_ALL for the Global Agreement.

3137:
3138: IF ( ( p_convert_to_base ) -- convert back to base currency
3139: AND ( l_base_currency <> l_po_currency ) ) THEN
3140:
3141: -- Get the rate from PO_HEADERS_ALL for the Global Agreement.
3142: SELECT rate
3143: INTO l_rate
3144: FROM po_headers_all
3145: WHERE po_header_id = p_po_header_id;

Line 3144: FROM po_headers_all

3140:
3141: -- Get the rate from PO_HEADERS_ALL for the Global Agreement.
3142: SELECT rate
3143: INTO l_rate
3144: FROM po_headers_all
3145: WHERE po_header_id = p_po_header_id;
3146:
3147: IF ( l_base_min_unit IS NOT NULL ) THEN
3148:

Line 3327: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

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: )
3331: IS

Line 3339: l_rate PO_HEADERS_ALL.rate%TYPE;

3335: l_po_precision FND_CURRENCIES.precision%TYPE;
3336: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3337: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3338:
3339: l_rate PO_HEADERS_ALL.rate%TYPE;
3340:
3341: BEGIN
3342: /*Bug11802312 - Exclude the records with consigned flag Y while calculating the amount released
3343: After this fix, document reference is retained and hence from header id and from line id will

Line 3439: l_rate PO_HEADERS_ALL.rate%TYPE;

3435: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3436: l_po_precision FND_CURRENCIES.precision%TYPE;
3437: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3438:
3439: l_rate PO_HEADERS_ALL.rate%TYPE;
3440: l_total NUMBER;
3441:
3442: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_GC_AMOUNT_RELEASED';
3443: l_progress VARCHAR2(3) := '000';

Line 3496: --Also added a join with PO_HEADERS_ALL for rate in header of execution document

3492: -- SQL Why: This is the return value
3493: --: added decode on value basis
3494:
3495: --Bug# 5391346: Added Decode for currency match condition
3496: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3497: --
3498: l_progress := '040';
3499:
3500: SELECT NVL(

Line 3546: PO_HEADERS_ALL PH1

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')
3550: AND POD.line_location_id = POLL.line_location_id --bug 12572504

Line 3565: --Also added a join with PO_HEADERS_ALL for rate in header of execution document

3561: --: added decode on value basis
3562:
3563: --Bug# 5391346: Added Decode for currency match condition
3564: --Use PO precision (ie Contract currency precision) when l_po_min_unit is null (PO implies the Contract here)
3565: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3566: --
3567: l_progress := '050';
3568:
3569: SELECT NVL(

Line 3614: PO_HEADERS_ALL PH1

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')
3618: AND POD.line_location_id = POLL.line_location_id --bug 12572504

Line 3637: --Also added a join with PO_HEADERS_ALL for rate in header of execution document

3633: --: added decode on value basis
3634:
3635: --Bug# 5391346: Added Decode for currency match condition
3636: --use only PO min unit and not PO precision when l_po_min_unit is not null (PO implies the Contract here)
3637: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3638: --
3639: l_progress := '070';
3640:
3641: SELECT NVL(

Line 3683: PO_HEADERS_ALL PH1

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')
3687: AND POD.line_location_id = POLL.line_location_id --bug 12572504

Line 3702: --Also added a join with PO_HEADERS_ALL for rate in header of execution document

3698: --: added decode on value basis
3699:
3700: --Bug# 5391346: Added Decode for currency match condition
3701: --use PO precision when PO currency min unit is null
3702: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3703: --
3704: l_progress := '080';
3705:
3706: SELECT NVL(

Line 3748: PO_HEADERS_ALL PH1

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')
3752: AND POD.line_location_id = POLL.line_location_id --bug 12572504

Line 3773: --Also added a join with PO_HEADERS_ALL for rate in header of execution document

3769: -- SQL Why: This is the return value
3770: --: added decode on value basis
3771:
3772: --Bug# 5391346: Added Decode for currency match condition
3773: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3774: --
3775: l_progress := '100';
3776: -- Bug# 13536418: Added hint to improve performance.
3777: SELECT /*+ use_nl(POLL,POD,PH1) index(POLL PO_LINE_LOCATIONS_N1) index(PH1 PO_HEADERS_U1) */ NVL(

Line 3819: PO_HEADERS_ALL PH,

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
3823: AND POL.po_line_id = POLL.po_line_id

Line 3820: PO_HEADERS_ALL PH1

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

Line 3838: --Also added a join with PO_HEADERS_ALL for rate in header of execution document

3834: -- SQL Why: This is the return value
3835: --: added decode on value basis
3836:
3837: --Bug# 5391346: Added Decode for currency match condition
3838: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3839: --
3840: l_progress := '110';
3841: -- Bug# 13536418: Added hint to improve performance.
3842: SELECT /*+ use_nl(POLL,POD,PH1) index(POLL PO_LINE_LOCATIONS_N1) index(PH1 PO_HEADERS_U1) */ NVL(

Line 3888: PO_HEADERS_ALL PH,

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 --
3892: AND POL.po_line_id = POLL.po_line_id

Line 3889: PO_HEADERS_ALL PH1

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

Line 5902: FROM po_headers_all ph

5898: into l_duplicate_exists
5899: from sys.dual
5900: where not exists
5901: (SELECT 'po number is not unique'
5902: FROM po_headers_all ph
5903: WHERE ph.segment1 = p_segment1
5904: AND ph.type_lookup_code IN
5905: ('STANDARD','CONTRACT','BLANKET','PLANNED')
5906: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));

Line 5950: FROM po_headers_all ph

5946: into l_duplicate_exists
5947: from sys.dual
5948: where not exists
5949: (SELECT 'rfq number is not unique'
5950: FROM po_headers_all ph
5951: WHERE ph.segment1 = p_segment1
5952: AND ph.type_lookup_code = 'RFQ'
5953: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5954:

Line 5982: FROM po_headers_all ph

5978: into l_duplicate_exists
5979: from sys.dual
5980: where not exists
5981: (SELECT 'quote number is not unique'
5982: FROM po_headers_all ph
5983: WHERE ph.segment1 = p_segment1
5984: AND ph.type_lookup_code = 'QUOTATION'
5985: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5986:

Line 6619: , PO_HEADERS_ALL POH

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
6622: AND POH.po_header_id = POD.po_header_id
6623: AND

Line 8033: header_last_update_date PO_HEADERS_ALL.last_update_date%type;

8029: --End of Comments
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;

Line 8037: doc_last_update_date PO_HEADERS_ALL.last_update_date%type;

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:
8041: l_module_name CONSTANT VARCHAR2(100) := 'GET_LAST_UPDATE_DATE_FOR_DOC';

Line 8039: min_date PO_HEADERS_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');

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:
8041: l_module_name CONSTANT VARCHAR2(100) := 'GET_LAST_UPDATE_DATE_FOR_DOC';
8042: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(g_log_head, l_module_name);
8043: d_pos NUMBER := 0;

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

8046: IF (PO_LOG.d_proc) THEN
8047: PO_LOG.proc_begin(d_module_base); PO_LOG.proc_begin(d_module_base, 'p_doc_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;

Line 8257: address_last_update_date po_headers_all_ext_b.last_update_date%type;

8253: line_last_update_date PO_LINES_DRAFT_ALL.last_update_date%type;
8254: line_loc_last_update_date PO_LINE_LOCATIONS_DRAFT_ALL.last_update_date%type;
8255: dist_last_update_date PO_DISTRIBUTIONS_DRAFT_ALL.last_update_date%type;
8256: mod_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8257: address_last_update_date po_headers_all_ext_b.last_update_date%type;
8258: org_assign_last_update_date po_ga_org_assign_draft.last_update_date%type;
8259: --Lowest date supported by database as we need to handle null dates
8260: min_date PO_HEADERS_DRAFT_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');
8261:

Line 8283: select nvl(max(last_update_date), min_date) into address_last_update_date from po_headers_all_ext_b where draft_id = p_doc_id;

8279: select nvl(max(last_update_date), min_date) into draft_last_update_date from po_drafts where draft_id = p_doc_id;
8280: d_pos := 60;
8281: -- Bugfix 9878931
8282: -- Fetch the last update date of the addresses of the modification document
8283: select nvl(max(last_update_date), min_date) into address_last_update_date from po_headers_all_ext_b where draft_id = p_doc_id;
8284: d_pos := 65;
8285: -- Bugfix 11774144
8286: select nvl(max(last_update_date), min_date) into org_assign_last_update_date from po_ga_org_assign_draft where draft_id = p_doc_id;
8287: d_pos := 70;