DBA Data[Home] [Help]

APPS.CSI_INV_DISCREPANCY_PKG dependencies on CSI_INV_DISCREPANCY_TEMP

Line 400: Insert Into CSI_INV_DISCREPANCY_TEMP

396: OR NVL(v_nl_trackable, 'N') <> 'Y'
397: Then
398:
399: Begin
400: Insert Into CSI_INV_DISCREPANCY_TEMP
401: (
402: discrepancy_id
403: ,inventory_item_id
404: ,serial_number

Line 929: INSERT INTO CSI_INV_DISCREPANCY_TEMP

925: THEN
926:
927: BEGIN
928:
929: INSERT INTO CSI_INV_DISCREPANCY_TEMP
930: (
931: discrepancy_id
932: ,inventory_item_id
933: ,serial_number

Line 1312: l_object_name := l_schema_name||'.csi_inv_discrepancy_temp';

1308: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1309: RAISE fnd_api.g_exc_error;
1310: END IF;
1311:
1312: l_object_name := l_schema_name||'.csi_inv_discrepancy_temp';
1313:
1314: -- Empty the discrepancy table before each run
1315: truncate_table(l_object_name);
1316: --

Line 1332: FROM CSI_INV_DISCREPANCY_TEMP;

1328: --
1329: BEGIN
1330: SELECT count(*)
1331: INTO l_disc_count
1332: FROM CSI_INV_DISCREPANCY_TEMP;
1333: END;
1334: --
1335: -- If there are any data discrepancies between IB and INV then display the report
1336: --