APPS.PO_CLM_COLS_SUB_CHECK dependencies on PO_LINES_ALL

Line 87: FROM po_lines_all

83: SELECT NVL(CLM_MAX_ORDER_AMOUNT, l_total_amt_ordered + 1),
84: NVL(CLM_MIN_ORDER_AMOUNT, l_total_amt_ordered - 1)
85: INTO l_idv_max_ord_amt,
86: l_idv_min_ord_amt
87: FROM po_lines_all
88: WHERE PO_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID
89: AND PO_LINE_ID = c_get_po_lines_rec.IDV_LINE_ID;
90:
91: d_progress := 80;

Line 348: FROM PO_LINES_ALL

344: SELECT CLM_ORDER_START_DATE,
345: CLM_ORDER_END_DATE
346: INTO l_ord_st_dt,
347: l_ord_end_dt
348: FROM PO_LINES_ALL
349: WHERE PO_LINE_ID = c_get_po_lines_rec.FROM_LINE_ID;
350:
351: SELECT CLM_EFFECTIVE_DATE
352: INTO l_effective_date

Line 1013: FROM PO_LINES_ALL

1009: d_progress := 60;
1010: BEGIN
1011: SELECT NVL(CLM_MIN_ORDER_QUANTITY, c_get_po_lines_rec.TOTAL_QTY - 1), NVL(CLM_MAX_ORDER_QUANTITY, c_get_po_lines_rec.TOTAL_QTY + 1)
1012: INTO l_idv_min_ord_qty, l_idv_max_ord_qty
1013: FROM PO_LINES_ALL
1014: WHERE PO_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID
1015: AND PO_LINE_ID = c_get_po_lines_rec.IDV_LINE_ID;
1016:
1017: d_progress := 70;

Line 1150: FROM PO_LINES_ALL

1146: d_progress := 60;
1147: BEGIN
1148: SELECT CLM_MAX_TOTAL_QUANTITY, CLM_TOTAL_QUANTITY_ORDERED
1149: INTO l_idv_max_qty, l_tot_qty_ordered
1150: FROM PO_LINES_ALL
1151: WHERE PO_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID
1152: AND PO_LINE_ID = c_get_po_lines_rec.IDV_LINE_ID;
1153:
1154: d_progress := 70;

Line 1325: FROM PO_LINES_ALL

1321: d_progress := 60;
1322: BEGIN
1323: SELECT CLM_MAX_TOTAL_AMOUNT, NVL(CLM_TOTAL_AMOUNT_ORDERED, 0)
1324: INTO l_idv_max_amt, l_tot_amt_ordered
1325: FROM PO_LINES_ALL
1326: WHERE PO_HEADER_ID = c_get_po_lines_rec.IDV_HEADER_ID
1327: AND PO_LINE_ID = c_get_po_lines_rec.IDV_LINE_ID;
1328:
1329: d_progress := 70;

Line 2369: FROM po_lines_all pol

2365:
2366: IF p_level = 'LINE' AND p_idv_line_id IS NOT NULL THEN
2367: SELECT pol.po_header_id
2368: INTO l_header_id
2369: FROM po_lines_all pol
2370: WHERE pol.po_line_id = p_doc_level_id;
2371: ELSIF p_level = 'HEADER' THEN
2372: l_header_id := p_doc_level_id;
2373: ELSE