APPS.PO_VAL_LINES2 dependencies on PO_LINE_TYPES_B

Line 275: FROM po_line_types_b plt

271: FROM DUAL
272: WHERE p_line_type_id_tbl(i) IS NOT NULL
273: AND EXISTS(
274: SELECT 1
275: FROM po_line_types_b plt
276: WHERE p_line_type_id_tbl(i) = plt.line_type_id
277: AND NVL(p_global_agreement_flag_tbl(i), 'N') = 'Y'
278: AND NVL(plt.outside_operation_flag, 'N') = 'Y');
279:

Line 1104: FROM po_line_types_b plt

1100: WHERE p_order_type_lookup_code_tbl(i) = 'QUANTITY'
1101: AND p_item_id_tbl(i) IS NULL
1102: AND EXISTS(
1103: SELECT 1
1104: FROM po_line_types_b plt
1105: WHERE p_line_type_id_tbl(i) IS NOT NULL
1106: AND p_line_type_id_tbl(i) = plt.line_type_id
1107: AND plt.outside_operation_flag = 'Y');
1108:

Line 1137: FROM po_line_types_b plt

1133: 'VALUE',
1134: p_item_id_tbl(i),
1135: DECODE(plt.outside_operation_flag, 'N', PO_VAL_CONSTANTS.c_item_id_valid,
1136: PO_VAL_CONSTANTS.c_item_id_op_valid)
1137: FROM po_line_types_b plt
1138: WHERE p_item_id_tbl(i) IS NOT NULL
1139: AND p_line_type_id_tbl(i) IS NOT NULL
1140: AND p_line_type_id_tbl(i) = plt.line_type_id
1141: AND plt.outside_operation_flag IS NOT NULL

Line 1440: FROM PO_LINE_TYPES_B pltb

1436: 'UNIT_MEAS_LOOKUP_CODE',
1437: p_unit_meas_lookup_code_tbl(i),
1438: pltb.unit_of_measure,
1439: PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type
1440: FROM PO_LINE_TYPES_B pltb
1441: WHERE pltb.line_type_id = p_line_type_id_tbl(i)
1442: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
1443: AND p_unit_meas_lookup_code_tbl(i) <> pltb.unit_of_measure;
1444:

Line 1980: FROM po_line_types_b plt

1976: IF (p_order_type_lookup_code_tbl(i) = 'AMOUNT') THEN
1977: /** unit price defaults from line type **/
1978: SELECT plt.unit_price
1979: INTO X_li_unit_price
1980: FROM po_line_types_b plt
1981: WHERE p_line_type_id_tbl(i) = plt.line_type_id;
1982:
1983: INSERT INTO po_validation_results_gt
1984: (result_set_id,

Line 2012: FROM po_line_types_b plt

2008: FROM DUAL
2009: WHERE p_line_type_id_tbl(i) IS NOT NULL
2010: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
2011: AND NOT EXISTS(SELECT 1
2012: FROM po_line_types_b plt
2013: WHERE p_line_type_id_tbl(i) = plt.line_type_id
2014: AND X_li_unit_price = plt.unit_price);
2015:
2016:

Line 2051: FROM po_line_types_b plt

2047: FROM DUAL
2048: WHERE p_line_type_id_tbl(i) IS NOT NULL
2049: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
2050: AND NOT EXISTS(SELECT 1
2051: FROM po_line_types_b plt
2052: WHERE p_line_type_id_tbl(i) = plt.line_type_id
2053: AND p_unit_price_tbl(i) = plt.unit_price);
2054:
2055: IF (SQL%ROWCOUNT > 0) THEN