DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on MTL_SYSTEM_ITEMS

Line 134: mtl_system_items_b_kfv msikfv,

130: wro.quantity_issued as "REQISSUEDQUANTITY",
131: eam_material_allocqty_pkg.open_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID,WRO.REQUIRED_QUANTITY,WRO.QUANTITY_ISSUED) as "REQQUANTITYOPEN" ,
132: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material
133: FROM
134: mtl_system_items_b_kfv msikfv,
135: MTL_SYSTEM_ITEMS M,
136: MTL_ITEM_LOCATIONS L,
137: MFG_LOOKUPS LU,
138: WIP_REQUIREMENT_OPERATIONS WRO,

Line 135: MTL_SYSTEM_ITEMS M,

131: eam_material_allocqty_pkg.open_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID,WRO.REQUIRED_QUANTITY,WRO.QUANTITY_ISSUED) as "REQQUANTITYOPEN" ,
132: eam_material_allocqty_pkg.allocated_quantity(WRO.WIP_ENTITY_ID,WRO.OPERATION_SEQ_NUM,WRO.ORGANIZATION_ID,WRO.INVENTORY_ITEM_ID) as "REQALLOCATEDQUANTITY")) Material
133: FROM
134: mtl_system_items_b_kfv msikfv,
135: MTL_SYSTEM_ITEMS M,
136: MTL_ITEM_LOCATIONS L,
137: MFG_LOOKUPS LU,
138: WIP_REQUIREMENT_OPERATIONS WRO,
139: MTL_ITEM_LOCATIONS_KFV milk

Line 153: FROM mtl_system_items

149: AND milk.organization_id (+) = wro.organization_id
150: AND LU.LOOKUP_TYPE = 'WIP_SUPPLY_SHORT'
151: AND LU.LOOKUP_CODE = WRO.WIP_SUPPLY_TYPE
152: AND wro.inventory_item_id in (SELECT inventory_item_id
153: FROM mtl_system_items
154: WHERE stock_enabled_flag = 'Y')
155: ORDER BY msikfv.concatenated_segments;
156:
157: -- Cursor for Resources

Line 500: mtl_system_items_kfv msik,

496: bic.component_quantity as "QUANTITY",
497: msik.primary_uom_code as "UOM",
498: lu.meaning as "SUPPLYTYPE")) AssetBom
499: from bom_inventory_components bic,
500: mtl_system_items_kfv msik,
501: wip_discrete_jobs wdj,
502: csi_item_instances cii,
503: bom_bill_of_materials bbom,
504: mfg_lookups lu

Line 531: mtl_system_items_kfv msik,

527: bic.component_quantity as "QUANTITY",
528: msik.primary_uom_code as "UOM",
529: lu.meaning as "SUPPLYTYPE")) AssetBom
530: from bom_inventory_components bic,
531: mtl_system_items_kfv msik,
532: wip_discrete_jobs wdj,
533: bom_bill_of_materials bbom,
534: mfg_lookups lu
535: where bic.effectivity_date <= sysdate

Line 783: mtl_system_items_b_kfv msi,

779: msi.concatenated_segments,
780: cii.instance_number,cii.serial_number into l_wip_entity_name,l_organization_id,l_asset_group,l_instance_number,l_serial_number
781: from wip_discrete_jobs wdj,
782: csi_item_instances cii,
783: mtl_system_items_b_kfv msi,
784: wip_entities we
785: where wdj.wip_entity_id=p_wip_entity_id(i)
786: and wdj.wip_entity_id=we.wip_entity_id
787: and cii.instance_id(+) = DECODE(wdj.maintenance_object_type,3,wdj.maintenance_object_id,NULL)

Line 793: from mtl_system_items_b_kfv msi,

789: and wdj.organization_id=msi.organization_id;
790:
791: begin
792: select msi.concatenated_segments into l_asset_activity
793: from mtl_system_items_b_kfv msi,
794: wip_discrete_jobs wdj
795: where wdj.primary_item_id=msi.inventory_item_id and
796: wdj.organization_id=msi.organization_id and
797: wdj.wip_entity_id=p_wip_entity_id(i) ;

Line 930: from mtl_system_items_kfv msi, wip_discrete_jobs wdj

926:
927: --Adding Asset Group Description
928: begin
929: select XMLConcat(XMLELEMENT("ASSETGRPDESC",msi.description),l_xmlTemp3) into l_xmlTemp3
930: from mtl_system_items_kfv msi, wip_discrete_jobs wdj
931: where nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msi.inventory_item_id
932: and wdj.organization_id=msi.organization_id
933: and wdj.wip_entity_id=p_wip_entity_id(i);
934: exception

Line 994: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2

990: fnd_date.date_to_displayDT(Convert_to_client_time(eps.base_date)) as "BASEDATE",
991: bd.description as "DEPTDESCRIPTION"),
992: XMLConcat(l_xmlTemp3,l_xmlTypeFailureData,l_xmlType1,l_xmlTypeOperation,l_xmlTypeMaterial,l_xmlTypeResource,l_xmlTypeDirectMaterial,l_xmlTypeShortAttachment,
993: l_xmlTypeLongAttachment,l_xmlTypefileattachment,l_xmlTypeWorkRequest,l_xmlTypeMeter,l_xmlTypeQualityPlan,l_xmlTypeAssetBom,l_xmlTypeAssetroutecomp))) AS "RESULT" into l_xmlType
994: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2
995: ,fnd_common_lookups flm1,fnd_common_lookups flm2,fnd_common_lookups flm3,fnd_common_lookups flm4 ,fnd_common_lookups flm5
996: where wewdv.wip_entity_id=p_wip_entity_id(i)
997: and msi.inventory_item_id(+)= wewdv.primary_item_id
998: and msi.organization_id(+)=wewdv.organization_id