DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on OE_TRANSACTION_TYPES_ALL

Line 1773: FROM oe_transaction_types_all hdr,

1769: l_order_line_type_id,
1770: l_line_price_list_id,
1771: l_order_line_category_code,
1772: l_scheduling_code
1773: FROM oe_transaction_types_all hdr,
1774: oe_transaction_types_all line
1775: WHERE hdr.transaction_Type_id = l_header_rec.order_type_id
1776: AND line.transaction_type_id = hdr.default_outbound_line_type_id
1777: AND hdr.org_id = l_source_operating_unit

Line 1774: oe_transaction_types_all line

1770: l_line_price_list_id,
1771: l_order_line_category_code,
1772: l_scheduling_code
1773: FROM oe_transaction_types_all hdr,
1774: oe_transaction_types_all line
1775: WHERE hdr.transaction_Type_id = l_header_rec.order_type_id
1776: AND line.transaction_type_id = hdr.default_outbound_line_type_id
1777: AND hdr.org_id = l_source_operating_unit
1778: AND line.org_id = l_source_operating_unit;