DBA Data[Home] [Help]

APPS.WSMPPCPD dependencies on MTL_SYSTEM_ITEMS

Line 875: FROM mtl_system_items msi

871: WHERE bbom.common_bill_sequence_id = x_bill_sequence_id
872: AND bbom.organization_id <> x_org_id
873: AND NOT EXISTS (
874: SELECT null
875: FROM mtl_system_items msi
876: WHERE msi.organization_id = bbom.organization_id
877: AND msi.inventory_item_id = x_substitute_component_id
878: AND msi.bom_enabled_flag = 'Y'
879: AND ((bbom.assembly_type = 1

Line 1007: FROM mtl_system_items msi

1003: WHERE bbom.common_bill_sequence_id = x_bill_sequence_id
1004: AND bbom.organization_id <> x_org_id
1005: AND NOT EXISTS
1006: (SELECT null
1007: FROM mtl_system_items msi
1008: WHERE msi.organization_id = bbom.organization_id
1009: AND msi.inventory_item_id = x_substitute_component_id
1010: AND msi.bom_enabled_flag = 'Y'
1011: AND ((bbom.assembly_type = 1

Line 1370: FROM mtl_system_items msi

1366: WHERE bbom.common_bill_sequence_id = rec.bill_sequence_id
1367: AND bbom.organization_id <> x_org_id
1368: AND NOT EXISTS (
1369: SELECT null
1370: FROM mtl_system_items msi
1371: WHERE msi.organization_id = bbom.organization_id
1372: AND msi.inventory_item_id = x_substitute_component_id
1373: AND msi.bom_enabled_flag = 'Y'
1374: AND ((bbom.assembly_type = 1

Line 1475: FROM mtl_system_items msi

1471: WHERE bbom.common_bill_sequence_id = rec.bill_sequence_id
1472: AND bbom.organization_id <> x_org_id
1473: AND NOT EXISTS
1474: (SELECT null
1475: FROM mtl_system_items msi
1476: WHERE msi.organization_id = bbom.organization_id
1477: AND msi.inventory_item_id = x_substitute_component_id
1478: AND msi.bom_enabled_flag = 'Y'
1479: AND ((bbom.assembly_type = 1

Line 3639: FROM mtl_system_items_kfv

3635: p_organization_id is NOT NULL Then
3636:
3637: SELECT substr(concatenated_segments, 1, 80)
3638: INTO l_prim_co_prod_name
3639: FROM mtl_system_items_kfv
3640: WHERE inventory_item_id = l_prim_co_prod_id
3641: AND organization_id = p_organization_id;
3642:
3643: Else

Line 3655: FROM mtl_system_items_kfv

3651:
3652: -- get the secondary co-product name
3653: SELECT substr(concatenated_segments, 1, 80)
3654: INTO l_co_product_name
3655: FROM mtl_system_items_kfv
3656: WHERE inventory_item_id = c_rec.co_product_id
3657: AND organization_id = p_organization_id;
3658:
3659: x_progress := '035';