eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_PICKING_PVT dependencies on BOM_BILL_OF_MATERIALS

Line 688: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs

684: a.bill_sequence_id,
685: wfs.primary_item_id,
686: wfs.SCHEDULED_COMPLETION_DATE,
687: wfs.planned_quantity
688: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs
689: where a.bill_sequence_id = b.common_bill_sequence_id
690: and b.assembly_item_id = wfs.primary_item_id
691: and wfs.wip_entity_id = v_wip_entity_id
692: and b.organization_id = wfs.organization_id

Line 696: from bom_bill_of_materials c

692: and b.organization_id = wfs.organization_id
693: and ( nvl(b.alternate_bom_designator, 'none') = nvl(wfs.alternate_bom_designator, 'none')
694: or ( b.alternate_bom_designator IS NULL
695: and not exists(select 'x'
696: from bom_bill_of_materials c
697: where c.assembly_item_id = wfs.primary_item_id
698: and c.organization_id = wfs.organization_id
699: and c.alternate_bom_designator = wfs.alternate_bom_designator
700: )

Line 1147: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs

1143: wfs.SCHEDULED_COMPLETION_DATE,
1144: wfs.planned_quantity
1145: into p_alloc_tbl(i).bill_org_id, p_alloc_tbl(i).bill_seq_id, l_itemID, l_abm,
1146: p_alloc_tbl(i).alt_rtg_dsg, l_reqDate, l_assemblyQty
1147: from bom_bill_of_materials a, bom_bill_of_materials b, wip_flow_schedules wfs
1148: where a.bill_sequence_id = b.common_bill_sequence_id
1149: and b.assembly_item_id = wfs.primary_item_id
1150: and wfs.wip_entity_id = p_alloc_tbl(i).wip_entity_id
1151: and b.organization_id = wfs.organization_id

Line 1155: from bom_bill_of_materials c

1151: and b.organization_id = wfs.organization_id
1152: and ( nvl(b.alternate_bom_designator, 'none') = nvl(wfs.alternate_bom_designator, 'none')
1153: or ( b.alternate_bom_designator IS NULL
1154: and not exists(select 'x'
1155: from bom_bill_of_materials c
1156: where c.assembly_item_id = wfs.primary_item_id
1157: and c.organization_id = wfs.organization_id
1158: and c.alternate_bom_designator = wfs.alternate_bom_designator
1159: )