DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WIP_REQUIREMENT_OPERATIONS

Line 3379: from wip_requirement_operations wro

3375: -- Check for possible explosion of phantom components.
3376: BEGIN
3377:
3378: Select 2 into p_manually_added_comp
3379: from wip_requirement_operations wro
3380: where wro.wip_entity_id = p_wip_entity_id
3381: and wro.organization_id = p_organization_id
3382: and wro.operation_seq_num = 0-p_op_seq_num -- -ve op seq num for exploded components.
3383: and wro.wip_supply_type = 6 -- Phantom components exploded

Line 3501: FROM wip_requirement_operations wro

3497: l_stmt_num := 90;
3498:
3499: SELECT 1
3500: INTO p_manually_added_comp
3501: FROM wip_requirement_operations wro
3502: WHERE wro.wip_entity_id = p_wip_entity_id
3503: AND wro.organization_id = p_organization_id
3504: AND wro.operation_seq_num = p_op_seq_num
3505: AND wro.required_quantity <> 0

Line 3523: FROM wip_requirement_operations wro

3519: l_stmt_num := 100;
3520:
3521: SELECT 1
3522: INTO p_manually_added_comp
3523: FROM wip_requirement_operations wro
3524: WHERE wro.wip_entity_id = p_wip_entity_id
3525: AND wro.organization_id = p_organization_id
3526: AND wro.operation_seq_num = p_op_seq_num
3527: AND wro.required_quantity <> 0