[Home] [Help]
6058: wip_move_txn_interface wmti,
6059: wip_operation_resources wor,
6060: bom_resources br,
6061: mtl_system_items msi,
6062: mtl_parameters mp,
6063: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
6064: bom_calendar_dates bcd4,
6065: -- bom_calendar_dates bcd1, Bug 4398047 join to bcd1 not required
6066: bom_calendar_dates bcd3,
6274: bom_calendar_dates bcd1,
6275: bom_calendar_dates bcd2,
6276: fnd_user fu,
6277: mtl_system_items msi,
6278: mtl_parameters mp,
6279: hr_organization_information hoi,
6280: wip_entities we,
6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6482: wip_move_txn_interface wmti,
6483: wip_operation_resources wor,
6484: bom_resources br,
6485: mtl_system_items msi,
6486: mtl_parameters mp,
6487: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6488: bom_calendar_dates bcd4,
6489: -- bom_calendar_dates bcd1, Bug 4398047 join no longer required
6490: bom_calendar_dates bcd3,
6716: bom_calendar_dates bcd2,
6717: fnd_user fu,
6718: mtl_item_revisions mir,
6719: mtl_system_items msi,
6720: mtl_parameters mp,
6721: hr_organization_information hoi,
6722: wip_operation_resources wor,
6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
7461:
7462: -- get primary cost method
7463: SELECT mp.primary_cost_method
7464: INTO l_pri_cost_method
7465: FROM mtl_parameters mp
7466: WHERE mp.organization_id = p_org_id;
7467:
7468: -- get mandatoty scrap flag
7469: SELECT wp.mandatory_scrap_flag
7575: 1) source_code,
7576: MMTT.PRIMARY_QUANTITY primary_quantity
7577: FROM wip_move_txn_interface wmti,
7578: mtl_material_transactions_temp mmtt,
7579: mtl_parameters mp
7580: WHERE wmti.group_id = p_group_id
7581: AND (p_txn_id IS NULL OR wmti.transaction_id = p_txn_id)
7582: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
7583: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
7635: -- check for snapshot transactions through the interface
7636: SELECT COUNT(*)
7637: INTO l_num_snapshot
7638: FROM wip_move_txn_interface wmti,
7639: mtl_parameters mp
7640: -- wip_parameters wp
7641: WHERE wmti.group_id = p_group_id
7642: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
7643: AND wmti.process_status = WIP_CONSTANTS.RUNNING
7663: UPDATE mtl_material_transactions_temp mmtt1
7664: SET mmtt1.transaction_temp_id = mtl_material_transactions_s.nextval
7665: WHERE exists ( SELECT 1
7666: FROM wip_move_txn_interface wmti,
7667: mtl_parameters mp,
7668: mtl_material_transactions_temp mmtt2
7669: WHERE wmti.group_id = p_group_id
7670: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
7671: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC