APPS.MTL_CCEOI_CONC_PVT dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 104: FROM mtl_cycle_count_entries

100: (cycle_count_header_id = cchid);
101: --
102: CURSOR L_CycleCount_Records_Csr(HID NUMBER, CCID IN NUMBER) IS
103: SELECT *
104: FROM mtl_cycle_count_entries
105: WHERE
106: (cycle_count_header_id = hid
107: OR cycle_count_entry_id = ccid)
108: AND NVL(export_flag, 2) = 2

Line 795: -- reset the export_flag in the mtl_cycle_count_entries table

791: --
792: FOR c_rec IN L_Purge_Iface_Csr LOOP
793: -- IS it an exported RECORD
794: IF c_rec.cycle_count_entry_id IS NOT NULL THEN
795: -- reset the export_flag in the mtl_cycle_count_entries table
796: MTL_CCEOI_PROCESS_PVT.Set_CCExport(
797: p_api_version => 0.9,
798: X_return_status=> L_return_status,
799: x_msg_count => L_msg_count,

Line 1288: Update mtl_cycle_count_entries

1284: commit;
1285: begin
1286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker: Unexport all of them successfully processed');
1287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Worker:'||to_char(P_CC_Interface_Group_ID));
1288: Update mtl_cycle_count_entries
1289: set export_flag = 2
1290: where cycle_count_entry_id
1291: in (select cycle_count_entry_id
1292: from mtl_cc_entries_interface where