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_CLM_COLS_SUB_CHECK dependencies on PO_HEADERS_GT

Line 50: FROM po_headers_gt

46: BEGIN
47: d_progress := 20;
48: SELECT TYPE_LOOKUP_CODE
49: INTO l_document_type_code
50: FROM po_headers_gt
51: WHERE PO_HEADER_ID = p_document_id;
52:
53: d_progress := 30;
54: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 184: FROM po_headers_gt

180: BEGIN
181: d_progress := 20;
182: SELECT TYPE_LOOKUP_CODE
183: INTO l_document_type_code
184: FROM po_headers_gt
185: WHERE PO_HEADER_ID = p_document_id;
186:
187: d_progress := 30;
188: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 202: FROM po_headers_gt

198: d_progress := 60;
199: BEGIN
200: SELECT CLM_MAX_ORDER_AMOUNT, AMOUNT_LIMIT
201: INTO l_idv_max_ord_amt, l_amt_limit
202: FROM po_headers_gt
203: WHERE PO_HEADER_ID = p_document_id;
204:
205: d_progress := 70;
206: PO_UDA_DEFAULTING_PKG.DEBUG('l_idv_max_ord_amt :' || l_idv_max_ord_amt , d_progress);

Line 323: FROM po_headers_gt

319: BEGIN
320: d_progress := 20;
321: SELECT TYPE_LOOKUP_CODE
322: INTO l_document_type_code
323: FROM po_headers_gt
324: WHERE PO_HEADER_ID = p_document_id;
325:
326: d_progress := 30;
327: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 353: FROM po_headers_gt

349: WHERE PO_LINE_ID = c_get_po_lines_rec.FROM_LINE_ID;
350:
351: SELECT CLM_EFFECTIVE_DATE
352: INTO l_effective_date
353: FROM po_headers_gt
354: WHERE PO_HEADER_ID = p_document_id;
355:
356: d_progress := 70;
357: PO_UDA_DEFAULTING_PKG.DEBUG('l_ord_st_dt :' || l_ord_st_dt , d_progress);

Line 464: FROM po_headers_gt

460: BEGIN
461: d_progress := 20;
462: SELECT TYPE_LOOKUP_CODE
463: INTO l_document_type_code
464: FROM po_headers_gt
465: WHERE PO_HEADER_ID = p_document_id;
466:
467: d_progress := 30;
468: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 483: FROM po_headers_gt

479: BEGIN
480:
481: SELECT START_DATE, END_DATE
482: INTO l_head_st_dt, l_head_end_dt
483: FROM po_headers_gt
484: WHERE PO_HEADER_ID = p_document_id;
485:
486: FOR c_get_po_lines_rec IN c_get_po_lines(p_document_id) LOOP
487:

Line 573: FROM po_headers_gt

569: BEGIN
570: d_progress := 20;
571: SELECT TYPE_LOOKUP_CODE
572: INTO l_document_type_code
573: FROM po_headers_gt
574: WHERE PO_HEADER_ID = p_document_id;
575:
576: d_progress := 30;
577: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 623: FROM PO_HEADERS_GT POH

619: p_sequence,
620: FND_MESSAGE.GET_STRING('PO',l_effect_dt_null_msg),
621: 'Effective date Invalid',
622: 'W'
623: FROM PO_HEADERS_GT POH
624: WHERE POH.PO_HEADER_ID = p_document_id
625: AND POH.CLM_EFFECTIVE_DATE IS NULL ;
626:
627: IF SQL%ROWCOUNT > 0 THEN

Line 665: FROM PO_HEADERS_GT POH,PO_LINES_GT POL,PO_LINE_LOCATIONS_GT PLL

661: p_sequence,
662: FND_MESSAGE.GET_STRING('PO','PO_EFFECT_DT_INVALID') || ' for Line '||POL.LINE_NUM_DISPLAY,
663: 'Effective date Invalid',
664: 'E'
665: FROM PO_HEADERS_GT POH,PO_LINES_GT POL,PO_LINE_LOCATIONS_GT PLL
666: WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
667: AND POL.PO_LINE_ID=PLL.PO_LINE_ID
668: -- AND POH.draft_id = p_draft_id
669: AND POH.PO_HEADER_ID = p_document_id

Line 737: FROM po_headers_gt

733: BEGIN
734: d_progress := 20;
735: SELECT TYPE_LOOKUP_CODE
736: INTO l_document_type_code
737: FROM po_headers_gt
738: WHERE PO_HEADER_ID = p_document_id;
739:
740: d_progress := 30;
741: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 851: FROM po_headers_gt

847: BEGIN
848: d_progress := 20;
849: SELECT TYPE_LOOKUP_CODE
850: INTO l_document_type_code
851: FROM po_headers_gt
852: WHERE PO_HEADER_ID = p_document_id;
853:
854: d_progress := 30;
855: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 992: FROM po_headers_gt

988: d_progress := 20;
989: BEGIN
990: SELECT TYPE_LOOKUP_CODE
991: INTO l_document_type_code
992: FROM po_headers_gt
993: WHERE PO_HEADER_ID = p_document_id;
994:
995: d_progress := 30;
996: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 1128: FROM po_headers_gt

1124: d_progress := 20;
1125: BEGIN
1126: SELECT TYPE_LOOKUP_CODE
1127: INTO l_document_type_code
1128: FROM po_headers_gt
1129: WHERE PO_HEADER_ID = p_document_id;
1130:
1131: d_progress := 30;
1132: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 1303: FROM po_headers_gt

1299: d_progress := 20;
1300: BEGIN
1301: SELECT TYPE_LOOKUP_CODE
1302: INTO l_document_type_code
1303: FROM po_headers_gt
1304: WHERE PO_HEADER_ID = p_document_id;
1305:
1306: d_progress := 30;
1307: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 1440: FROM po_headers_gt

1436: d_progress := 20;
1437: BEGIN
1438: SELECT TYPE_LOOKUP_CODE, CLM_SOURCE_DOCUMENT_ID
1439: INTO l_document_type_code, l_idv_header_id
1440: FROM po_headers_gt
1441: WHERE PO_HEADER_ID = p_document_id;
1442:
1443: d_progress := 30;
1444: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 1554: FROM po_headers_gt

1550: d_progress := 20;
1551: BEGIN
1552: SELECT TYPE_LOOKUP_CODE, CLM_SOURCE_DOCUMENT_ID
1553: INTO l_document_type_code, l_idv_header_id
1554: FROM po_headers_gt
1555: WHERE PO_HEADER_ID = p_document_id;
1556:
1557: d_progress := 30;
1558: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 1689: FROM po_headers_gt

1685:
1686: BEGIN
1687: SELECT TYPE_LOOKUP_CODE, CLM_SOURCE_DOCUMENT_ID
1688: INTO l_document_type_code, l_source_id
1689: FROM po_headers_gt
1690: WHERE PO_HEADER_ID = p_document_id;
1691:
1692: d_progress := 30;
1693: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 1719: FROM po_headers_gt h, po_lines_gt l

1715:
1716: d_progress := 70;
1717: SELECT 1
1718: INTO l_count
1719: FROM po_headers_gt h, po_lines_gt l
1720: WHERE h.PO_HEADER_ID = p_document_id
1721: AND h.CLM_AWARD_TYPE IS NOT NULL
1722: AND h.PO_HEADER_ID = l.PO_HEADER_ID
1723: AND (l.FROM_HEADER_ID IS NOT NULL OR h.CLM_SOURCE_DOCUMENT_ID IS NOT NULL)

Line 1732: FROM po_headers_gt h, po_lines_gt l

1728:
1729: d_progress := 70;
1730: SELECT 1
1731: INTO l_count
1732: FROM po_headers_gt h, po_lines_gt l
1733: WHERE h.PO_HEADER_ID = p_document_id
1734: AND h.CLM_AWARD_TYPE IS NOT NULL
1735: AND h.PO_HEADER_ID = l.PO_HEADER_ID
1736: AND (l.CONTRACT_ID IS NOT NULL OR h.CLM_SOURCE_DOCUMENT_ID IS NOT NULL)

Line 1830: FROM po_headers_gt

1826:
1827: BEGIN
1828: SELECT TYPE_LOOKUP_CODE, CLM_SOURCE_DOCUMENT_ID
1829: INTO l_document_type_code, l_source_id
1830: FROM po_headers_gt
1831: WHERE PO_HEADER_ID = p_document_id;
1832:
1833: d_progress := 30;
1834: PO_UDA_DEFAULTING_PKG.DEBUG('l_document_type_code :' || l_document_type_code , d_progress);

Line 2381: FROM po_headers_gt poh

2377: IF l_header_id IS NOT NULL THEN
2378:
2379: SELECT poh.currency_code, poh.org_id
2380: INTO l_po_currency, l_org_id
2381: FROM po_headers_gt poh
2382: WHERE poh.po_header_id = l_header_id;
2383:
2384: d_position := 20;
2385:

Line 2519: FROM po_headers_gt poh

2515: d_position := 10;
2516:
2517: SELECT poh.currency_code, poh.org_id
2518: INTO l_po_currency, l_org_id
2519: FROM po_headers_gt poh
2520: WHERE poh.po_header_id = p_header_id;
2521:
2522: d_position := 20;
2523: