APPS.BOM_DELETE_GROUPS_API dependencies on BOM_DELETE_SUB_ENTITIES

Line 239: BOM_DELETE_SUB_ENTITIES bdsubent

235: IS
236: SELECT 1
237: FROM
238: BOM_DELETE_ENTITIES bdent,
239: BOM_DELETE_SUB_ENTITIES bdsubent
240: WHERE
241: bdent.DELETE_ENTITY_SEQUENCE_ID = bdsubent.DELETE_ENTITY_SEQUENCE_ID(+)
242: AND ( ( bdent.DELETE_STATUS_TYPE = 3 ) OR ( bdsubent.DELETE_STATUS_TYPE = 3 ) )
243: AND bdent.DELETE_GROUP_SEQUENCE_ID = c_delete_group_id;

Line 402: FROM BOM_DELETE_ENTITIES A, BOM_DELETE_SUB_ENTITIES B,

398: to_char(B.EFFECTIVITY_DATE, 'YYYY/MM/DD HH24:MI') effectivity_date,
399: A.ITEM_CONCAT_SEGMENTS item_name,
400: B.COMPONENT_CONCAT_SEGMENTS comp_name,
401: B.description description
402: FROM BOM_DELETE_ENTITIES A, BOM_DELETE_SUB_ENTITIES B,
403: MTL_PARAMETERS MP
404: WHERE A.DELETE_GROUP_SEQUENCE_ID = p_group_id
405: AND B.DELETE_STATUS_TYPE in (1,2,3)
406: AND A.DELETE_ENTITY_SEQUENCE_ID =

Line 684: UPDATE BOM_DELETE_SUB_ENTITIES

680: /*
681: ** set the status
682: */
683:
684: UPDATE BOM_DELETE_SUB_ENTITIES
685: SET DELETE_STATUS_TYPE = action_status,
686: DELETE_DATE = decode(action_status, 4,
687: sysdate, NULL),
688: LAST_UPDATE_DATE = sysdate,