[Home] [Help]
1546: gLoginId, -- last_update_login
1547: null, -- program_application_id,??
1548: null, -- program_id,??
1549: sysdate -- program_update_date
1550: from bom_parameters bp, bom_bill_of_materials bbom
1551: where bp.organization_id = pRcvOrgId
1552: and bp.organization_id = bbom.organization_id (+)
1553: and pModelItemId = bbom.assembly_item_id (+)
1554: and bbom.alternate_bom_designator is null
1657: gLoginId, -- last_update_login
1658: null, -- program_application_id,??
1659: null, -- program_id,??
1660: sysdate -- program_update_date
1661: from bom_parameters bp, bom_bill_of_materials bbom
1662: where bp.organization_id = pRcvOrgId
1663: and bp.organization_id = bbom.organization_id (+)
1664: and pModelItemId = bbom.assembly_item_id (+)
1665: and bbom.alternate_bom_designator is null
1773: gLoginId, -- last_update_login
1774: null, -- program_application_id,??
1775: null, -- program_id,??
1776: sysdate -- program_update_date
1777: from bom_parameters bp, bom_bill_of_materials bbom
1778: where bp.organization_id = pRcvOrgId
1779: and bp.organization_id = bbom.organization_id (+)
1780: and pModelItemId = bbom.assembly_item_id (+)
1781: and bbom.alternate_bom_designator is null
2550: gLoginId, -- last_update_login
2551: null, -- program_application_id,??
2552: null, -- program_id,??
2553: sysdate -- program_update_date
2554: from bom_bill_of_materials bom, bom_parameters bp
2555: where p_organization_id = bp.organization_id
2556: and p_model_item_id = bom.assembly_item_id(+)
2557: and bp.organization_id = bom.organization_id(+)
2558: and bom.alternate_bom_designator is null
4772: gLoginId, -- last_update_login
4773: null, -- program_application_id,??
4774: null, -- program_id,??
4775: sysdate -- program_update_date
4776: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4777: where msi.inventory_item_id = p_model_item_id
4778: and msi.inventory_item_id = bom.assembly_item_id(+)
4779: and msi.organization_id = bom.organization_id(+)
4780: and bom.alternate_bom_designator is null
4852: gLoginId, -- last_update_login
4853: null, -- program_application_id,??
4854: null, -- program_id,??
4855: sysdate -- program_update_date
4856: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4857: where msi.inventory_item_id = p_model_item_id
4858: and msi.inventory_item_id = bom.assembly_item_id(+)
4859: and msi.organization_id = bom.organization_id(+)
4860: and bom.alternate_bom_designator is null
5009: gLoginId, -- last_update_login
5010: null, -- program_application_id,??
5011: null, -- program_id,??
5012: sysdate -- program_update_date
5013: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
5014: where msi.inventory_item_id = p_model_item_id
5015: and msi.inventory_item_id = bom.assembly_item_id(+)
5016: and msi.organization_id = bom.organization_id(+)
5017: and bom.alternate_bom_designator is null
5679: and model_item_id = p_model_item_id
5680: and organization_id = v_receiving_org
5681: and rcv_org_id = v_receiving_org
5682: and exists
5683: ( select * from bom_parameters bp, bom_bill_of_materials bbom
5684: where bp.organization_id = v_receiving_org
5685: and bbom.organization_id = bp.organization_id
5686: and bbom.assembly_item_id = p_model_item_id
5687: and bp.create_config_bom = 'Y' ) ;
5711: where line_id = p_line_id
5712: and model_item_id = p_model_item_id
5713: and rcv_org_id in (
5714: select bp.organization_id
5715: from bom_parameters bp, bom_bill_of_materials bbom
5716: where bbom.organization_id = bp.organization_id
5717: and bbom.assembly_item_id = p_model_item_id
5718: and bp.create_config_bom = 'Y' )
5719: and rownum = 1 ;