APPS.EAM_PROCESS_WO_PUB dependencies on WIP_EAM_DIRECT_ITEMS

Line 5604: FROM wip_eam_direct_items wedi

5600: attribute12 ,
5601: attribute13 ,
5602: attribute14 ,
5603: attribute15
5604: FROM wip_eam_direct_items wedi
5605: WHERE wedi.wip_entity_id = p_wip_entity_id
5606: AND wedi.organization_id = p_organization_id;
5607:
5608: BEGIN

Line 6213: /* This procedure is used to make an entry in wip_eam_direct_items

6209:
6210: END PROCESS_MASTER_CHILD_WO;
6211:
6212:
6213: /* This procedure is used to make an entry in wip_eam_direct_items
6214: when a Purchase Requisition/Purchase Order is created for description direct items in
6215: Purchasing using forms.This procedure is called from purchasing code.
6216: Bug 8450377
6217: */

Line 6269: from wip_eam_direct_items wed

6265: if x_direct_item_sequence_id is not null then
6266: select sum(count) into l_count from
6267: (
6268: select count(*) as count
6269: from wip_eam_direct_items wed
6270: where wed.wip_entity_id = p_wip_entity_id and
6271: wed.operation_seq_num = p_operation_seq_num and
6272: wed.direct_item_sequence_id = x_direct_item_sequence_id and
6273: wed.organization_id = p_organization_id

Line 6315: select count(*) into l_count from wip_eam_direct_items wed where

6311: return ;
6312: end if;
6313: end if;
6314:
6315: select count(*) into l_count from wip_eam_direct_items wed where
6316: wed.wip_entity_id = p_wip_entity_id and
6317: wed.operation_seq_num = p_operation_seq_num and
6318: wed.description = p_description and
6319: wed.organization_id = p_organization_id;

Line 6324: from wip_eam_direct_items wed where

6320:
6321: --Entry is already there. return the direct item sequence id.
6322: if l_count > 0 then
6323: select max(direct_item_sequence_id) into x_direct_item_sequence_id
6324: from wip_eam_direct_items wed where
6325: wed.wip_entity_id = p_wip_entity_id and
6326: wed.operation_seq_num = p_operation_seq_num and
6327: wed.description = p_description and
6328: wed.organization_id = p_organization_id;

Line 6350: INSERT INTO WIP_EAM_DIRECT_ITEMS

6346: IF(p_uom IS NOT null) THEN -- 9727518
6347: select distinct uom_code into l_uom_code from mtl_uom_conversions muc where muc.unit_of_measure = p_uom;
6348: END IF;
6349:
6350: INSERT INTO WIP_EAM_DIRECT_ITEMS
6351: (
6352: DESCRIPTION
6353: , PURCHASING_CATEGORY_ID
6354: , DIRECT_ITEM_SEQUENCE_ID