[Home] [Help]
5924: wip_move_txn_interface wmti,
5925: wip_operation_resources wor,
5926: bom_resources br,
5927: mtl_system_items msi,
5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
5930: bom_calendar_dates bcd4,
5931: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
5932: bom_calendar_dates bcd3,
6133: bom_calendar_dates bcd1,
6134: bom_calendar_dates bcd2,
6135: fnd_user fu,
6136: mtl_system_items msi,
6137: mtl_parameters mp,
6138: hr_organization_information hoi,
6139: wip_entities we,
6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6334: wip_move_txn_interface wmti,
6335: wip_operation_resources wor,
6336: bom_resources br,
6337: mtl_system_items msi,
6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6340: bom_calendar_dates bcd4,
6341: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6342: bom_calendar_dates bcd3,
6561: bom_calendar_dates bcd2,
6562: fnd_user fu,
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,
6565: mtl_parameters mp,
6566: hr_organization_information hoi,
6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
7259:
7260: -- get primary cost method
7261: SELECT mp.primary_cost_method
7262: INTO l_pri_cost_method
7263: FROM mtl_parameters mp
7264: WHERE mp.organization_id = p_org_id;
7265:
7266: -- get mandatoty scrap flag
7267: SELECT wp.mandatory_scrap_flag
7373: 1) source_code,
7374: MMTT.PRIMARY_QUANTITY primary_quantity
7375: FROM wip_move_txn_interface wmti,
7376: mtl_material_transactions_temp mmtt,
7377: mtl_parameters mp
7378: WHERE wmti.group_id = p_group_id
7379: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)
7380: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
7381: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
7433: -- check for snapshot transactions through the interface
7434: SELECT COUNT(*)
7435: INTO l_num_snapshot
7436: FROM wip_move_txn_interface wmti,
7437: mtl_parameters mp
7438: -- wip_parameters wp
7439: WHERE wmti.group_id = p_group_id
7440: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
7441: AND wmti.process_status = WIP_CONSTANTS.RUNNING
7461: WHERE mmtt1.rowid IN
7462: (SELECT mmtt1.rowid
7463: FROM wip_move_txn_interface wmti,
7464: -- wip_parameters wp,
7465: mtl_parameters mp,
7466: mtl_material_transactions_temp mmtt2
7467: WHERE wmti.group_id = p_group_id
7468: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
7469: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC