DBA Data[Home] [Help]

APPS.CSFW_DEBRIEF_PUB dependencies on OE_TRANSACTION_TYPES_ALL

Line 1690: from oe_transaction_types_all

1686:
1687:
1688: cursor c_line_type_id_order (p_order_type_id number,p_incident_id Number) is
1689: select default_outbound_line_type_id
1690: from oe_transaction_types_all
1691: where transaction_type_id = p_order_type_id
1692: and transaction_type_code = 'ORDER';
1693:
1694: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is

Line 1696: from oe_transaction_types_all

1692: and transaction_type_code = 'ORDER';
1693:
1694: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is
1695: select default_inbound_line_type_id
1696: from oe_transaction_types_all
1697: where transaction_type_id = p_order_type_id
1698: and transaction_type_code = 'ORDER';
1699:
1700:

Line 2365: from oe_transaction_types_all

2361:
2362:
2363: cursor c_line_type_id_order (p_order_type_id number,p_incident_id Number) is
2364: select default_outbound_line_type_id
2365: from oe_transaction_types_all
2366: where transaction_type_id = p_order_type_id
2367: and transaction_type_code = 'ORDER';
2368:
2369: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is

Line 2371: from oe_transaction_types_all

2367: and transaction_type_code = 'ORDER';
2368:
2369: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is
2370: select default_inbound_line_type_id
2371: from oe_transaction_types_all
2372: where transaction_type_id = p_order_type_id
2373: and transaction_type_code = 'ORDER';
2374:
2375: Cursor c_status_meaning(p_code Varchar2) Is