APPS.PO_VAL_LINES2 dependencies on PO_LINE_TYPES_B

Line 267: FROM po_line_types_b plt

263: FROM DUAL
264: WHERE p_line_type_id_tbl(i) IS NOT NULL
265: AND EXISTS(
266: SELECT 1
267: FROM po_line_types_b plt
268: WHERE p_line_type_id_tbl(i) = plt.line_type_id
269: AND NVL(p_global_agreement_flag_tbl(i), 'N') = 'Y'
270: AND NVL(plt.outside_operation_flag, 'N') = 'Y');
271:

Line 1095: FROM po_line_types_b plt

1091: WHERE p_order_type_lookup_code_tbl(i) = 'QUANTITY'
1092: AND p_item_id_tbl(i) IS NULL
1093: AND EXISTS(
1094: SELECT 1
1095: FROM po_line_types_b plt
1096: WHERE p_line_type_id_tbl(i) IS NOT NULL
1097: AND p_line_type_id_tbl(i) = plt.line_type_id
1098: AND plt.outside_operation_flag = 'Y');
1099:

Line 1128: FROM po_line_types_b plt

1124: 'VALUE',
1125: p_item_id_tbl(i),
1126: DECODE(plt.outside_operation_flag, 'N', PO_VAL_CONSTANTS.c_item_id_valid,
1127: PO_VAL_CONSTANTS.c_item_id_op_valid)
1128: FROM po_line_types_b plt
1129: WHERE p_item_id_tbl(i) IS NOT NULL
1130: AND p_line_type_id_tbl(i) IS NOT NULL
1131: AND p_line_type_id_tbl(i) = plt.line_type_id
1132: AND plt.outside_operation_flag IS NOT NULL

Line 1431: FROM PO_LINE_TYPES_B pltb

1427: 'UNIT_MEAS_LOOKUP_CODE',
1428: p_unit_meas_lookup_code_tbl(i),
1429: pltb.unit_of_measure,
1430: PO_VAL_CONSTANTS.c_unit_meas_lookup_line_type
1431: FROM PO_LINE_TYPES_B pltb
1432: WHERE pltb.line_type_id = p_line_type_id_tbl(i)
1433: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
1434: AND p_unit_meas_lookup_code_tbl(i) <> pltb.unit_of_measure;
1435:

Line 1993: FROM po_line_types_b plt

1989: FROM DUAL
1990: WHERE p_line_type_id_tbl(i) IS NOT NULL
1991: AND p_order_type_lookup_code_tbl(i) = 'AMOUNT'
1992: AND NOT EXISTS(SELECT 1
1993: FROM po_line_types_b plt
1994: WHERE p_line_type_id_tbl(i) = plt.line_type_id
1995: AND p_unit_price_tbl(i) = plt.unit_price);
1996:
1997: IF (SQL%ROWCOUNT > 0) THEN