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_LINES_GT

Line 35: FROM po_lines_gt

31:
32: CURSOR c_get_po_lines(p_document_id NUMBER) IS
33: SELECT FROM_HEADER_ID IDV_HEADER_ID, LINE_NUM,
34: FROM_LINE_ID IDV_LINE_ID, PO_LINE_ID
35: FROM po_lines_gt
36: WHERE PO_HEADER_ID = p_document_id
37: AND CLM_INFO_FLAG <> 'Y';
38:
39: BEGIN

Line 170: FROM po_lines_gt

166:
167: CURSOR c_get_idv_lines(p_document_id NUMBER) IS
168: SELECT LINE_NUM,
169: PO_LINE_ID
170: FROM po_lines_gt
171: WHERE PO_HEADER_ID = p_document_id;
172:
173: BEGIN
174: d_progress := 10;

Line 297: FROM po_lines_gt

293: )
294: IS
295: CURSOR c_get_po_lines(p_document_id NUMBER) IS
296: SELECT FROM_LINE_ID, LINE_NUM
297: FROM po_lines_gt
298: WHERE PO_HEADER_ID = p_document_id
299: AND CLM_INFO_FLAG <> 'Y';
300:
301: l_ord_st_dt DATE;

Line 450: FROM po_lines_gt

446: l_api_name CONSTANT VARCHAR2(100) := 'CLM_ORD_DT_LINE_WITIN_DT_HEAD';
447:
448: CURSOR c_get_po_lines(p_document_id NUMBER) IS
449: SELECT CLM_ORDER_START_DATE, CLM_ORDER_END_DATE, LINE_NUM
450: FROM po_lines_gt
451: WHERE PO_HEADER_ID = p_document_id;
452:
453: BEGIN
454: d_progress := 10;

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 716: FROM po_lines_gt

712: CLM_MAX_TOTAL_QUANTITY,
713: CLM_MIN_TOTAL_QUANTITY,
714: QUANTITY QUANTITY,
715: MATCHING_BASIS, LINE_NUM
716: FROM po_lines_gt
717: WHERE PO_HEADER_ID = p_document_id
718: AND CLM_INFO_FLAG <> 'Y';
719:
720: l_document_type_code VARCHAR2(100);

Line 829: FROM po_lines_gt

825: MATCHING_BASIS,
826: AMOUNT AMOUNT,
827: QUANTITY QUANTITY,
828: NVL(UNIT_PRICE, 0) UNIT_PRICE, LINE_NUM
829: FROM po_lines_gt
830: WHERE PO_HEADER_ID = p_document_id
831: AND CLM_INFO_FLAG <> 'Y';
832:
833: l_document_type_code VARCHAR2(100);

Line 975: FROM po_lines_gt

971: SELECT NVL(SUM(QUANTITY), 0) TOTAL_QTY,
972: FROM_HEADER_ID IDV_HEADER_ID,
973: FROM_LINE_ID IDV_LINE_ID,
974: MATCHING_BASIS
975: FROM po_lines_gt
976: WHERE PO_HEADER_ID = p_document_id
977: AND CLM_INFO_FLAG <> 'Y'
978: AND MATCHING_BASIS = 'QUANTITY'
979: GROUP BY FROM_HEADER_ID, FROM_LINE_ID, MATCHING_BASIS;

Line 1040: FROM po_lines_gt

1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037:
1038: SELECT MIN(LINE_NUM)
1039: INTO l_line_num
1040: FROM po_lines_gt
1041: WHERE PO_HEADER_ID = p_document_id
1042: AND CLM_INFO_FLAG <> 'Y'
1043: AND MATCHING_BASIS = 'QUANTITY'
1044: AND FROM_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID

Line 1111: FROM po_lines_gt

1107: SELECT NVL(SUM(QUANTITY), 0) TOTAL_QTY,
1108: FROM_HEADER_ID IDV_HEADER_ID,
1109: FROM_LINE_ID IDV_LINE_ID,
1110: MATCHING_BASIS
1111: FROM po_lines_gt
1112: WHERE PO_HEADER_ID = p_document_id
1113: AND CLM_INFO_FLAG <> 'Y'
1114: AND MATCHING_BASIS = 'QUANTITY'
1115: GROUP BY FROM_HEADER_ID, FROM_LINE_ID, MATCHING_BASIS;

Line 1217: FROM po_lines_gt

1213: x_return_status := FND_API.G_RET_STS_ERROR;
1214:
1215: SELECT MIN(LINE_NUM)
1216: INTO l_line_num
1217: FROM po_lines_gt
1218: WHERE PO_HEADER_ID = p_document_id
1219: AND CLM_INFO_FLAG <> 'Y'
1220: AND MATCHING_BASIS = 'QUANTITY'
1221: AND FROM_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID

Line 1284: FROM po_lines_gt

1280:
1281: CURSOR c_get_po_lines(p_document_id NUMBER) IS
1282: SELECT FROM_HEADER_ID IDV_HEADER_ID, PO_LINE_ID ,
1283: FROM_LINE_ID IDV_LINE_ID, LINE_NUM
1284: FROM po_lines_gt
1285: WHERE PO_HEADER_ID = p_document_id
1286: AND CLM_INFO_FLAG <> 'Y';
1287:
1288: l_total_line_amt_ordered NUMBER;

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 1810: FROM po_lines_gt l

1806: l_doc_type VARCHAR2(100);
1807:
1808: CURSOR c_get_po_lines(p_document_id NUMBER) IS
1809: SELECT LINE_NUM
1810: FROM po_lines_gt l
1811: WHERE l.PO_HEADER_ID = p_document_id
1812: AND l.FROM_LINE_ID IS NULL
1813: and nvl(l.CLM_INFO_FLAG,'N') = 'N' ; --Bug 12669019
1814: /*Bug 12669019 : If the Line is an Info line then The

Line 2421: FROM po_lines_gt pol

2417: )
2418: )
2419: )
2420: INTO l_return_val
2421: FROM po_lines_gt pol
2422: WHERE pol.po_header_id = p_doc_level_id
2423: AND (
2424: (pol.from_header_id = p_idv_header_id AND pol.FROM_LINE_ID = NVL(p_idv_line_id, pol.FROM_LINE_ID))
2425: OR

Line 2441: FROM po_lines_gt pol

2437: ,round((pol.quantity * pol.unit_price), l_precision)
2438: )
2439: )
2440: INTO l_return_val
2441: FROM po_lines_gt pol
2442: WHERE pol.po_line_id = p_doc_level_id
2443: AND (
2444: (pol.from_header_id = p_idv_header_id AND pol.FROM_LINE_ID = p_idv_line_id)
2445: OR