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 1369: PO_HEADERS_ALL PH

1365: c.precision
1366: INTO x_min_unit,
1367: x_precision
1368: FROM FND_CURRENCIES C,
1369: PO_HEADERS_ALL PH
1370: WHERE PH.po_header_id = x_object_id
1371: AND C.currency_code = PH.CURRENCY_CODE;
1372:
1373: if x_min_unit is null then

Line 1576: PO_HEADERS_ALL PH

1572: c.precision
1573: INTO x_min_unit,
1574: x_precision
1575: FROM FND_CURRENCIES C,
1576: PO_HEADERS_ALL PH
1577: WHERE PH.po_header_id = x_object_id
1578: AND C.currency_code = PH.CURRENCY_CODE;
1579:
1580: /* 958792 kbenjami 8/25/99. Proprogated fix from R11.

Line 1828: PO_HEADERS_ALL PH

1824: c.precision
1825: INTO x_min_unit,
1826: x_precision
1827: FROM FND_CURRENCIES C,
1828: PO_HEADERS_ALL PH
1829: WHERE PH.po_header_id = x_object_id
1830: AND C.currency_code = PH.CURRENCY_CODE;
1831:
1832: /* 716188 - SVAIDYAN : Changed the sql stmt to select only Standard and Planned

Line 1873: PO_HEADERS_ALL PH,

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
1875: --,FND_CURRENCIES C
1876: WHERE PH.po_header_id = x_object_id
1877: AND PH.po_header_id = PL.contract_id --

Line 1874: PO_HEADERS_ALL PH1

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
1875: --,FND_CURRENCIES C
1876: WHERE PH.po_header_id = x_object_id
1877: AND PH.po_header_id = PL.contract_id --
1878: --AND PH.currency_code = C.currency_code

Line 1907: PO_HEADERS_ALL PH,

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
1909: --,FND_CURRENCIES C
1910: WHERE PH.po_header_id = x_object_id
1911: AND PH.po_header_id = PL.contract_id --

Line 1908: PO_HEADERS_ALL PH1

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
1909: --,FND_CURRENCIES C
1910: WHERE PH.po_header_id = x_object_id
1911: AND PH.po_header_id = PL.contract_id --
1912: --AND PH.currency_code = C.currency_code

Line 1929: FROM PO_HEADERS_ALL POH,

1925: SELECT GSB.currency_code,
1926: POH.currency_code
1927: INTO x_base_currency,
1928: x_po_currency
1929: FROM PO_HEADERS_ALL POH,
1930: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
1931: GL_SETS_OF_BOOKS GSB,
1932: PO_RELEASES_ALL POR
1933: WHERE POR.po_release_id = x_object_id

Line 2064: PO_HEADERS_ALL PH

2060: INTO x_min_unit,
2061: x_precision
2062: FROM FND_CURRENCIES C,
2063: PO_RELEASES_ALL POR,
2064: PO_HEADERS_ALL PH
2065: WHERE POR.po_release_id = x_object_id
2066: AND PH.po_header_id = POR.PO_HEADER_ID
2067: AND C.currency_code = PH.CURRENCY_CODE;
2068:

Line 2134: PO_HEADERS_ALL PH,

2130: sum(c.precision)
2131: INTO x_min_unit,
2132: x_precision
2133: FROM FND_CURRENCIES C,
2134: PO_HEADERS_ALL PH,
2135: PO_LINES_ALL POL
2136: WHERE POL.po_line_id = x_object_id
2137: AND PH.po_header_id = POL.po_header_id
2138: AND C.currency_code = PH.CURRENCY_CODE;

Line 2201: PO_HEADERS_ALL PH,

2197: c.precision
2198: INTO x_min_unit,
2199: x_precision
2200: FROM FND_CURRENCIES C,
2201: PO_HEADERS_ALL PH,
2202: PO_LINE_LOCATIONS_ALL PLL
2203: WHERE PLL.line_location_id = x_object_id
2204: AND PH.po_header_id = PLL.po_header_id
2205: AND C.currency_code = PH.CURRENCY_CODE;

Line 2303: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2299: p_doc_type IN VARCHAR2,
2300: p_doc_subtype IN VARCHAR2,
2301: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2302:
2303: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2307: l_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2300: p_doc_subtype IN VARCHAR2,
2301: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2302:
2303: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2304: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2305: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2306: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2307: l_precision FND_CURRENCIES.PRECISION%TYPE;
2308: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2410: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2406: p_doc_subtype IN VARCHAR2,
2407: p_doc_revision IN NUMBER,
2408: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2409:
2410: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2414: l_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;

2407: p_doc_revision IN NUMBER,
2408: p_base_cur_result IN VARCHAR2) RETURN NUMBER IS
2409:
2410: l_base_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2411: l_po_currency PO_HEADERS_ALL.CURRENCY_CODE%TYPE;
2412: l_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2413: l_base_min_unit FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
2414: l_precision FND_CURRENCIES.PRECISION%TYPE;
2415: l_base_precision FND_CURRENCIES.PRECISION%TYPE;

Line 2502: PO_HEADERS_ALL PH,

2498: c.precision
2499: INTO l_min_unit,
2500: l_precision
2501: FROM FND_CURRENCIES C,
2502: PO_HEADERS_ALL PH,
2503: PO_LINE_LOCATIONS_ALL PLL
2504: WHERE PLL.line_location_id = p_object_id
2505: AND PH.po_header_id = PLL.po_header_id
2506: AND C.currency_code = PH.CURRENCY_CODE;

Line 2564: PO_HEADERS_ALL PH,

2560: sum(c.precision)
2561: INTO l_min_unit,
2562: l_precision
2563: FROM FND_CURRENCIES C,
2564: PO_HEADERS_ALL PH,
2565: PO_LINES_ALL POL
2566: WHERE POL.po_line_id = p_object_id
2567: AND PH.po_header_id = POL.po_header_id
2568: AND C.currency_code = PH.CURRENCY_CODE;

Line 2632: FROM PO_HEADERS_ALL POH,

2628: SELECT GSB.currency_code,
2629: POH.currency_code
2630: INTO l_base_currency,
2631: l_po_currency
2632: FROM PO_HEADERS_ALL POH,
2633: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2634: GL_SETS_OF_BOOKS GSB,
2635: PO_RELEASES_ALL POR
2636: WHERE POR.po_release_id = p_object_id

Line 2782: PO_HEADERS_ALL PH

2778: INTO l_min_unit,
2779: l_precision
2780: FROM FND_CURRENCIES C,
2781: PO_RELEASES_ALL POR,
2782: PO_HEADERS_ALL PH
2783: WHERE POR.po_release_id = p_object_id
2784: AND PH.po_header_id = POR.PO_HEADER_ID
2785: AND C.currency_code = PH.CURRENCY_CODE;
2786:

Line 2900: PO_HEADERS_ALL PH,

2896: sum(c.precision)
2897: INTO x_min_unit,
2898: x_precision
2899: FROM FND_CURRENCIES C,
2900: PO_HEADERS_ALL PH,
2901: PO_LINES_ALL POL
2902: WHERE POL.po_line_id = p_line_id
2903: AND PH.po_header_id = POL.po_header_id
2904: AND C.currency_code = PH.CURRENCY_CODE;

Line 2961: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE,

2957:
2958: ===================================================================================*/
2959: FUNCTION get_ga_amount_released
2960: (
2961: p_po_header_id PO_HEADERS_ALL.po_header_id%TYPE,
2962: p_convert_to_base BOOLEAN := FALSE
2963: )
2964: RETURN NUMBER
2965: IS

Line 2976: l_rate PO_HEADERS_ALL.rate%TYPE;

2972: l_po_precision FND_CURRENCIES.precision%TYPE;
2973: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
2974: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
2975:
2976: l_rate PO_HEADERS_ALL.rate%TYPE;
2977:
2978: x_total NUMBER;
2979:
2980: BEGIN

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

3005:
3006: IF ( ( p_convert_to_base ) -- convert back to base currency
3007: AND ( l_base_currency <> l_po_currency ) ) THEN
3008:
3009: -- Get the rate from PO_HEADERS_ALL for the Global Agreement.
3010: SELECT rate
3011: INTO l_rate
3012: FROM po_headers_all
3013: WHERE po_header_id = p_po_header_id;

Line 3012: FROM po_headers_all

3008:
3009: -- Get the rate from PO_HEADERS_ALL for the Global Agreement.
3010: SELECT rate
3011: INTO l_rate
3012: FROM po_headers_all
3013: WHERE po_header_id = p_po_header_id;
3014:
3015: IF ( l_base_min_unit IS NOT NULL ) THEN
3016:

Line 3198: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,

3194: ===================================================================================*/
3195: PROCEDURE get_ga_line_amount_released
3196: (
3197: p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE,
3198: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE,
3199: x_quantity_released OUT NOCOPY NUMBER,
3200: x_amount_released OUT NOCOPY NUMBER
3201: )
3202: IS

Line 3210: l_rate PO_HEADERS_ALL.rate%TYPE;

3206: l_po_precision FND_CURRENCIES.precision%TYPE;
3207: l_po_ext_precision FND_CURRENCIES.extended_precision%TYPE;
3208: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3209:
3210: l_rate PO_HEADERS_ALL.rate%TYPE;
3211:
3212: BEGIN
3213:
3214: -- Get the currency code defined for the PO

Line 3305: l_rate PO_HEADERS_ALL.rate%TYPE;

3301: l_po_currency FND_CURRENCIES.currency_code%TYPE;
3302: l_po_precision FND_CURRENCIES.precision%TYPE;
3303: l_po_min_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
3304:
3305: l_rate PO_HEADERS_ALL.rate%TYPE;
3306: l_total NUMBER;
3307:
3308: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_GC_AMOUNT_RELEASED';
3309: l_progress VARCHAR2(3) := '000';

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

3355: -- SQL Why: This is the return value
3356: --: added decode on value basis
3357:
3358: --Bug# 5391346: Added Decode for currency match condition
3359: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3360:
3361: l_progress := '040';
3362:
3363: SELECT NVL(

Line 3409: PO_HEADERS_ALL PH1

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
3411: AND POL.po_line_id = POLL.po_line_id
3412: AND POLL.shipment_type in ('STANDARD','PLANNED')
3413: AND POD.line_location_id(+) = POLL.line_location_id

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

3422: --: added decode on value basis
3423:
3424: --Bug# 5391346: Added Decode for currency match condition
3425: --Use PO precision (ie Contract currency precision) when l_po_min_unit is null (PO implies the Contract here)
3426: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3427:
3428: l_progress := '050';
3429:
3430: SELECT NVL(

Line 3475: PO_HEADERS_ALL PH1

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
3477: AND POL.po_line_id = POLL.po_line_id
3478: AND POLL.shipment_type in ('STANDARD','PLANNED')
3479: AND POD.line_location_id(+) = POLL.line_location_id

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

3492: --: added decode on value basis
3493:
3494: --Bug# 5391346: Added Decode for currency match condition
3495: --use only PO min unit and not PO precision when l_po_min_unit is not null (PO implies the Contract here)
3496: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3497:
3498: l_progress := '070';
3499:
3500: SELECT NVL(

Line 3542: PO_HEADERS_ALL PH1

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
3544: AND POL.po_line_id = POLL.po_line_id
3545: AND POLL.shipment_type in ('STANDARD','PLANNED')
3546: AND POD.line_location_id(+) = POLL.line_location_id

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

3555: --: added decode on value basis
3556:
3557: --Bug# 5391346: Added Decode for currency match condition
3558: --use PO precision when PO currency min unit is null
3559: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3560:
3561: l_progress := '080';
3562:
3563: SELECT NVL(

Line 3605: PO_HEADERS_ALL PH1

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
3607: AND POL.po_line_id = POLL.po_line_id
3608: AND POLL.shipment_type in ('STANDARD','PLANNED')
3609: AND POD.line_location_id(+) = POLL.line_location_id

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

3624: -- SQL Why: This is the return value
3625: --: added decode on value basis
3626:
3627: --Bug# 5391346: Added Decode for currency match condition
3628: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3629: l_progress := '100';
3630:
3631: SELECT NVL(
3632: SUM(

Line 3673: PO_HEADERS_ALL PH,

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
3675: WHERE PH.po_header_id = p_po_header_id
3676: AND PH.po_header_id = POL.contract_id
3677: AND POL.po_line_id = POLL.po_line_id

Line 3674: PO_HEADERS_ALL PH1

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
3675: WHERE PH.po_header_id = p_po_header_id
3676: AND PH.po_header_id = POL.contract_id
3677: AND POL.po_line_id = POLL.po_line_id
3678: AND POLL.shipment_type in ('STANDARD','PLANNED')

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

3686: -- SQL Why: This is the return value
3687: --: added decode on value basis
3688:
3689: --Bug# 5391346: Added Decode for currency match condition
3690: --Also added a join with PO_HEADERS_ALL for rate in header of execution document
3691:
3692: l_progress := '110';
3693:
3694: SELECT NVL(

Line 3740: PO_HEADERS_ALL PH,

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
3742: WHERE PH.po_header_id = p_po_header_id
3743: AND PH.po_header_id = POL.contract_id --
3744: AND POL.po_line_id = POLL.po_line_id

Line 3741: PO_HEADERS_ALL PH1

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
3742: WHERE PH.po_header_id = p_po_header_id
3743: AND PH.po_header_id = POL.contract_id --
3744: AND POL.po_line_id = POLL.po_line_id
3745: AND POLL.shipment_type in ('STANDARD','PLANNED')

Line 5694: FROM po_headers_all ph

5690: into l_duplicate_exists
5691: from sys.dual
5692: where not exists
5693: (SELECT 'po number is not unique'
5694: FROM po_headers_all ph
5695: WHERE ph.segment1 = p_segment1
5696: AND ph.type_lookup_code IN
5697: ('STANDARD','CONTRACT','BLANKET','PLANNED')
5698: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));

Line 5742: FROM po_headers_all ph

5738: into l_duplicate_exists
5739: from sys.dual
5740: where not exists
5741: (SELECT 'rfq number is not unique'
5742: FROM po_headers_all ph
5743: WHERE ph.segment1 = p_segment1
5744: AND ph.type_lookup_code = 'RFQ'
5745: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5746:

Line 5774: FROM po_headers_all ph

5770: into l_duplicate_exists
5771: from sys.dual
5772: where not exists
5773: (SELECT 'quote number is not unique'
5774: FROM po_headers_all ph
5775: WHERE ph.segment1 = p_segment1
5776: AND ph.type_lookup_code = 'QUOTATION'
5777: AND nvl(ph.org_id, -99) = nvl(p_org_id, -99));
5778:

Line 6411: , PO_HEADERS_ALL POH

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
6414: AND POH.po_header_id = POD.po_header_id
6415: AND

Line 7825: header_last_update_date PO_HEADERS_ALL.last_update_date%type;

7821: --End of Comments
7822: -------------------------------------------------------------------------------
7823: FUNCTION get_last_update_date_for_doc(p_doc_header_id IN NUMBER) RETURN DATE
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;

Line 7829: doc_last_update_date PO_HEADERS_ALL.last_update_date%type;

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

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

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

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

7838: IF (PO_LOG.d_proc) THEN
7839: PO_LOG.proc_begin(d_module_base); PO_LOG.proc_begin(d_module_base, 'p_doc_header_id', p_doc_header_id);
7840: END IF;
7841: d_pos := 10;
7842: 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;
7843: d_pos := 20;
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;