APPS.XNB_SALES_ORDER_PVT dependencies on ECX_TP_DETAILS

Line 124: FROM ECX_TP_DETAILS_V

120:
121:
122: cursor l_tp_codes is
123: SELECT SOURCE_TP_LOCATION_CODE
124: FROM ECX_TP_DETAILS_V
125: WHERE TRANSACTION_TYPE = 'XNB' AND TRANSACTION_SUBTYPE = 'CBODI';
126:
127: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;
128:

Line 127: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;

123: SELECT SOURCE_TP_LOCATION_CODE
124: FROM ECX_TP_DETAILS_V
125: WHERE TRANSACTION_TYPE = 'XNB' AND TRANSACTION_SUBTYPE = 'CBODI';
126:
127: l_tp_code ecx_tp_details.source_tp_location_code%TYPE;
128:
129: BEGIN
130:
131: l_transaction_type := g_xnb_transation_type;