DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on WIP_PARAMETERS

Line 1789: FROM wip_parameters

1785: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
1786:
1787: SELECT propagate_job_change_to_po
1788: INTO l_propagate_job_change_to_po
1789: FROM wip_parameters
1790: WHERE organization_id = l_rs_txn.org_id;
1791:
1792: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
1793: wip_osp.updatePOReqQuantity(

Line 2523: FROM wip_parameters

2519: po_code_release_grp.PRC_11i_Family_Pack_J) THEN
2520:
2521: SELECT propagate_job_change_to_po
2522: INTO l_propagate_job_change_to_po
2523: FROM wip_parameters
2524: WHERE organization_id = l_dj_txn.org_id;
2525:
2526: IF(l_propagate_job_change_to_po = WIP_CONSTANTS.YES) THEN
2527: wip_osp.updatePOReqQuantity(

Line 6073: wip_parameters wp /*ER 4276433*/

6069: hr_organization_information hoi,
6070: wip_discrete_jobs wdj,
6071: wip_operations wo1,
6072: wip_operations wo2,
6073: wip_parameters wp /*ER 4276433*/
6074: WHERE wmti.group_id = p_gib.group_id
6075: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6076: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6077: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 6287: wip_parameters wp /*ER 4276433*/

6283: wip_operations wo1,
6284: wip_operations wo2,
6285: wip_move_txn_allocations wma,
6286: wip_move_txn_interface wmti,
6287: wip_parameters wp /*ER 4276433*/
6288: WHERE wmti.group_id = p_gib.group_id
6289: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6290: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6291: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 6497: wip_parameters wp /*ER 4276433*/

6493: hr_organization_information hoi,
6494: wip_discrete_jobs wdj,
6495: wip_operations wo1,
6496: wip_operations wo2,
6497: wip_parameters wp /*ER 4276433*/
6498: WHERE wmti.group_id = p_gib.group_id
6499: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6500: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6501: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 6729: wip_parameters wp /*ER 4276433*/

6725: wip_operations wo1,
6726: wip_operations wo2,
6727: wip_move_txn_allocations wma,
6728: wip_move_txn_interface wmti,
6729: wip_parameters wp /*ER 4276433*/
6730: WHERE wmti.group_id = p_gib.group_id
6731: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6732: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6733: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 7471: FROM wip_parameters wp

7467:
7468: -- get mandatoty scrap flag
7469: SELECT wp.mandatory_scrap_flag
7470: INTO l_mandatory_scrap_flag
7471: FROM wip_parameters wp
7472: WHERE wp.organization_id = p_org_id;
7473:
7474: IF((l_pri_cost_method = WIP_CONSTANTS.COST_AVG OR
7475: l_pri_cost_method = WIP_CONSTANTS.COST_FIFO OR

Line 7640: -- wip_parameters wp

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

Line 7914: wip_parameters mp

7910: wmti.primary_quantity)) changed_qty,
7911: GREATEST(wmti.fm_operation_seq_num, wmti.to_operation_seq_num) fm_op
7912: FROM wip_move_txn_interface wmti,
7913: wip_move_txn_allocations wmta,
7914: wip_parameters mp
7915: WHERE wmti.transaction_id = wmta.transaction_id (+)
7916: AND wmti.organization_id = wmta.organization_id (+)
7917: AND wmti.group_id = p_gib.group_id
7918: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)