APPS.CSP_PARTS_ORDER dependencies on OE_TRANSACTION_TYPES_ALL

Line 1566: FROM oe_transaction_types_all ot

1562: AND ROWNUM = 1;
1563:
1564: CURSOR validate_order_type (v_org_id number, v_order_type_id number) IS
1565: SELECT 1
1566: FROM oe_transaction_types_all ot
1567: WHERE ot.org_id = v_org_id
1568: AND ot.transaction_type_id = v_order_type_id
1569: AND sysdate BETWEEN NVL(ot.start_date_active, sysdate-1)
1570: AND NVL(ot.end_date_active, sysdate+1);

Line 2282: FROM oe_transaction_types_all hdr,

2278: l_order_line_type_id,
2279: l_line_price_list_id,
2280: l_order_line_category_code,
2281: l_scheduling_code
2282: FROM oe_transaction_types_all hdr,
2283: oe_transaction_types_all line
2284: WHERE hdr.transaction_Type_id = l_header_rec.order_type_id
2285: AND line.transaction_type_id = hdr.default_outbound_line_type_id
2286: AND hdr.org_id = l_source_operating_unit

Line 2283: oe_transaction_types_all line

2279: l_line_price_list_id,
2280: l_order_line_category_code,
2281: l_scheduling_code
2282: FROM oe_transaction_types_all hdr,
2283: oe_transaction_types_all line
2284: WHERE hdr.transaction_Type_id = l_header_rec.order_type_id
2285: AND line.transaction_type_id = hdr.default_outbound_line_type_id
2286: AND hdr.org_id = l_source_operating_unit
2287: AND line.org_id = l_source_operating_unit;