APPS.WIP_MOVPROC_PRIV dependencies on WIP_PARAMETERS

Line 1668: FROM wip_parameters

1664: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
1665:
1666: SELECT propagate_job_change_to_po
1667: INTO l_propagate_job_change_to_po
1668: FROM wip_parameters
1669: WHERE organization_id = l_rs_txn.org_id;
1670:
1671: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
1672: wip_osp.updatePOReqQuantity(

Line 2398: FROM wip_parameters

2394: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
2395:
2396: SELECT propagate_job_change_to_po
2397: INTO l_propagate_job_change_to_po
2398: FROM wip_parameters
2399: WHERE organization_id = l_dj_txn.org_id;
2400:
2401: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
2402: wip_osp.updatePOReqQuantity(

Line 7269: FROM wip_parameters wp

7265:
7266: -- get mandatoty scrap flag
7267: SELECT wp.mandatory_scrap_flag
7268: INTO l_mandatory_scrap_flag
7269: FROM wip_parameters wp
7270: WHERE wp.organization_id = p_org_id;
7271:
7272: IF((l_pri_cost_method = WIP_CONSTANTS.COST_AVG OR
7273: l_pri_cost_method = WIP_CONSTANTS.COST_FIFO OR

Line 7438: -- wip_parameters wp

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
7442: AND wmti.organization_id = mp.organization_id

Line 7464: -- wip_parameters wp,

7460: SET mmtt1.transaction_temp_id = mtl_material_transactions_s.nextval
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)

Line 7713: wip_parameters mp

7709: wmti.primary_quantity)) changed_qty,
7710: GREATEST(wmti.fm_operation_seq_num, wmti.to_operation_seq_num) fm_op
7711: FROM wip_move_txn_interface wmti,
7712: wip_move_txn_allocations wmta,
7713: wip_parameters mp
7714: WHERE wmti.transaction_id = wmta.transaction_id (+)
7715: AND wmti.organization_id = wmta.organization_id (+)
7716: AND wmti.group_id = p_gib.group_id
7717: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)