APPS.CSI_INV_DISCREPANCY_PKG dependencies on XNP_MSGS

Line 83: From xnp_msgs

79: msg_status,
80: body_text,
81: creation_date,
82: description
83: From xnp_msgs
84: Where (msg_code Like 'CSI%' OR msg_code Like 'CSE%')
85: And nvl(msg_status, 'READY') <> 'PROCESSED'
86: And recipient_name Is Null;
87:

Line 108: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';

104: IF l_return_status <> fnd_api.g_ret_sts_success THEN
105: RAISE fnd_api.g_exc_error;
106: END IF;
107:
108: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';
109:
110: -- truncate the temporary table before each run
111: truncate_table(l_object_name);
112:

Line 136: Insert Into csi_xnp_msgs_temp(

132: xnp_xml_utils.decode(l_msg_text, 'MTL_TRANSACTION_ID', l_source_id);
133: l_source_type := 'MTL_TRANSACTION_ID';
134: End If;
135:
136: Insert Into csi_xnp_msgs_temp(
137: msg_id,
138: msg_code,
139: msg_text,
140: msg_status,

Line 253: -- Load the csi_xnp_msgs_temp table with the records pending in the SFM queue

249: Begin
250:
251: debug('start of the IB_INV_Disc program for Non-serialized items..');
252:
253: -- Load the csi_xnp_msgs_temp table with the records pending in the SFM queue
254: decode_queue;
255: --
256: --
257: Open INV_ONH_BAL_CUR;

Line 328: From CSI_XNP_MSGS_TEMP xnp,

324:
325: Begin
326: Select Count(*)
327: Into l_error_count
328: From CSI_XNP_MSGS_TEMP xnp,
329: MTL_MATERIAL_TRANSACTIONS mmt
330: Where xnp.source_id = mmt.transaction_id
331: And xnp.source_type = 'MTL_TRANSACTION_ID'
332: And mmt.inventory_item_id = inventory_item_id_mig(i)

Line 906: FROM CSI_XNP_MSGS_TEMP xnp

902: l_count := 0;
903: BEGIN
904: SELECT COUNT(*)
905: INTO l_error_count
906: FROM CSI_XNP_MSGS_TEMP xnp
907: WHERE xnp.source_id IS NOT NULL
908: AND xnp.source_id = all_txn.mtl_txn_id
909: AND xnp.source_type = 'MTL_TRANSACTION_ID'
910: AND nvl(xnp.msg_status, 'READY') <> 'PROCESSED';