[Home] [Help]
1552: gLoginId, -- last_update_login
1553: null, -- program_application_id,??
1554: null, -- program_id,??
1555: sysdate -- program_update_date
1556: from bom_parameters bp, bom_bill_of_materials bbom
1557: where bp.organization_id = pRcvOrgId
1558: and bp.organization_id = bbom.organization_id (+)
1559: and pModelItemId = bbom.assembly_item_id (+)
1560: and bbom.alternate_bom_designator is null
1685: gLoginId, -- last_update_login
1686: null, -- program_application_id,??
1687: null, -- program_id,??
1688: sysdate -- program_update_date
1689: from bom_parameters bp, bom_bill_of_materials bbom
1690: where bp.organization_id = pRcvOrgId
1691: and bp.organization_id = bbom.organization_id (+)
1692: and pModelItemId = bbom.assembly_item_id (+)
1693: and bbom.alternate_bom_designator is null
1817: gLoginId, -- last_update_login
1818: null, -- program_application_id,??
1819: null, -- program_id,??
1820: sysdate -- program_update_date
1821: from bom_parameters bp, bom_bill_of_materials bbom
1822: where bp.organization_id = pRcvOrgId
1823: and bp.organization_id = bbom.organization_id (+)
1824: and pModelItemId = bbom.assembly_item_id (+)
1825: and bbom.alternate_bom_designator is null
2563: gLoginId, -- last_update_login
2564: null, -- program_application_id,??
2565: null, -- program_id,??
2566: sysdate -- program_update_date
2567: from bom_bill_of_materials bom, bom_parameters bp
2568: where p_organization_id = bp.organization_id
2569: and p_model_item_id = bom.assembly_item_id(+)
2570: and bp.organization_id = bom.organization_id(+)
2571: and bom.alternate_bom_designator is null
4255: gLoginId, -- last_update_login
4256: null, -- program_application_id,??
4257: null, -- program_id,??
4258: sysdate -- program_update_date
4259: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4260: where msi.inventory_item_id = p_model_item_id
4261: and msi.inventory_item_id = bom.assembly_item_id(+)
4262: and msi.organization_id = bom.organization_id(+)
4263: and bom.alternate_bom_designator is null
4335: gLoginId, -- last_update_login
4336: null, -- program_application_id,??
4337: null, -- program_id,??
4338: sysdate -- program_update_date
4339: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4340: where msi.inventory_item_id = p_model_item_id
4341: and msi.inventory_item_id = bom.assembly_item_id(+)
4342: and msi.organization_id = bom.organization_id(+)
4343: and bom.alternate_bom_designator is null
4484: gLoginId, -- last_update_login
4485: null, -- program_application_id,??
4486: null, -- program_id,??
4487: sysdate -- program_update_date
4488: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4489: where msi.inventory_item_id = p_model_item_id
4490: and msi.inventory_item_id = bom.assembly_item_id(+)
4491: and msi.organization_id = bom.organization_id(+)
4492: and bom.alternate_bom_designator is null
5149: and model_item_id = p_model_item_id
5150: and organization_id = v_receiving_org
5151: and rcv_org_id = v_receiving_org
5152: and exists
5153: ( select * from bom_parameters bp, bom_bill_of_materials bbom
5154: where bp.organization_id = v_receiving_org
5155: and bbom.organization_id = bp.organization_id
5156: and bbom.assembly_item_id = p_model_item_id
5157: and bp.create_config_bom = 'Y' ) ;
5181: where line_id = p_line_id
5182: and model_item_id = p_model_item_id
5183: and rcv_org_id in (
5184: select bp.organization_id
5185: from bom_parameters bp, bom_bill_of_materials bbom
5186: where bbom.organization_id = bp.organization_id
5187: and bbom.assembly_item_id = p_model_item_id
5188: and bp.create_config_bom = 'Y' )
5189: and rownum = 1 ;