[Home] [Help]
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
3384: and wro.required_quantity <> 0
3385: and NOT EXISTS (select 1
3386: from bom_inventory_components bic, wip_discrete_jobs wdj
3387: where bic.bill_sequence_id = NVL(wdj.common_bom_sequence_id, -999)
3388: and bic.component_item_id = wro.inventory_item_id
3389: and (bic.operation_seq_num = l_rtg_op_seq_num -- NOTE:use of BOS opseq Num
3390: or
3423: --VJ: End Additions to fix bug #2378859--
3424:
3425: -- This sql checks if there are any components that the user "intends to" issue
3426: -- manually. This pl/sql block looks for components in WRO that are not
3427: -- present in bom_inventory_components. It does not matter whether or not the user
3428: -- has already issued this material to job currently, what matters is recording the
3429: -- user's "intention" to issue these matls manually.
3430:
3431: -- added by BBK.
3504: AND wro.operation_seq_num = p_op_seq_num
3505: AND wro.required_quantity <> 0
3506: AND NOT EXISTS (
3507: select 1
3508: from bom_inventory_components bic, wip_discrete_jobs wdj
3509: where bic.bill_sequence_id = NVL(wdj.common_bom_sequence_id, -999)
3510: and bic.component_item_id = wro.inventory_item_id
3511: --and bic.operation_seq_num in (1, l_rtg_op_seq_num) -- NOTE:use of BOS opseq Num
3512: and (bic.operation_seq_num = l_rtg_op_seq_num -- NOTE:use of BOS opseq Num
3526: AND wro.operation_seq_num = p_op_seq_num
3527: AND wro.required_quantity <> 0
3528: AND NOT EXISTS (
3529: select 1
3530: from bom_inventory_components bic, wip_discrete_jobs wdj
3531: where bic.bill_sequence_id = NVL(wdj.common_bom_sequence_id, -999)
3532: and bic.component_item_id = wro.inventory_item_id
3533: and bic.operation_seq_num = l_rtg_op_seq_num -- NOTE:use of BOS opseq Num
3534: and wdj.wip_entity_id = wro.wip_entity_id
4273: begin
4274:
4275: select component_quantity, component_yield_factor
4276: into l_component_quantity, l_component_yield_factor
4277: from bom_inventory_components
4278: where bill_sequence_id = p_bill_seq_id
4279: and component_item_id = p_component_item_id
4280: and (operation_seq_num = p_start_seq_num or operation_seq_num = 1)
4281: and p_bom_revision_date between effectivity_date and nvl(disable_date, p_bom_revision_date + 1);