DBA Data[Home] [Help]

APPS.AMW_CREATE_LINES_PKG dependencies on ENG_SUBJECT_ENTITIES

Line 392: ,eng_subject_entities ese

388: ,ESE.SUBJECT_ID
389: INTO L_LINE_TYPE_ID
390: ,L_CHANGE_SUBJECT_ID
391: from eng_change_order_types ecot
392: ,eng_subject_entities ese
393: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
394: and ecot.SUBJECT_ID=ese.subject_id
395: AND ESE.ENTITY_NAME='AMW_LINE_PROCESS_ETTY'
396: AND ESE.PARENT_ENTITY_NAME='AMW_REVISION_ETTY'

Line 461: ,eng_subject_entities ese

457: ,ESE.SUBJECT_ID
458: INTO L_DELETE_LINE_TYPE_ID
459: ,L_DELETE_CHANGE_SUBJECT_ID
460: from eng_change_order_types ecot
461: ,eng_subject_entities ese
462: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
463: and ecot.SUBJECT_ID=ese.subject_id
464: AND ESE.ENTITY_NAME='AMW_LINE_DEL_PROCESS_ETTY'
465: AND ESE.PARENT_ENTITY_NAME='AMW_REVISION_ETTY'

Line 506: ,eng_subject_entities ese

502: ,ESE.SUBJECT_ID
503: INTO L_LINE_TYPE_ID
504: ,L_CHANGE_SUBJECT_ID
505: from eng_change_order_types ecot
506: ,eng_subject_entities ese
507: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
508: and ecot.SUBJECT_ID=ese.subject_id
509: AND ESE.ENTITY_NAME='AMW_LINE_RISK_ETTY'
510: AND ESE.PARENT_ENTITY_NAME='AMW_REVISION_ETTY'

Line 621: ,eng_subject_entities ese

617: ,ESE.SUBJECT_ID
618: INTO L_LINE_TYPE_ID
619: ,L_CHANGE_SUBJECT_ID
620: from eng_change_order_types ecot
621: ,eng_subject_entities ese
622: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
623: and ecot.SUBJECT_ID=ese.subject_id
624: AND ESE.ENTITY_NAME='AMW_LINE_CTRL_ETTY'
625: AND ESE.PARENT_ENTITY_NAME='AMW_REVISION_ETTY'

Line 638: ,eng_subject_entities ese

634: ,ESE.SUBJECT_ID
635: INTO L_DELETE_LINE_TYPE_ID
636: ,L_DELETE_CHANGE_SUBJECT_ID
637: from eng_change_order_types ecot
638: ,eng_subject_entities ese
639: where ecot.change_mgmt_type_code='AMW_PROCESS_RL_APPROVAL'
640: and ecot.SUBJECT_ID=ese.subject_id
641: AND ESE.ENTITY_NAME='AMW_LINE_DEL_CTRL_ETTY'
642: AND ESE.PARENT_ENTITY_NAME='AMW_REVISION_ETTY'

Line 1161: ,eng_subject_entities ese

1157: ,ESE.SUBJECT_ID
1158: INTO L_LINE_TYPE_ID
1159: ,L_CHANGE_SUBJECT_ID
1160: from eng_change_order_types ecot
1161: ,eng_subject_entities ese
1162: where ecot.change_mgmt_type_code='AMW_PROCESS_ORG_APPROVAL'
1163: and ecot.SUBJECT_ID=ese.subject_id
1164: AND ESE.ENTITY_NAME='AMW_ORG_LINE_CTRL_ETTY'
1165: AND ESE.PARENT_ENTITY_NAME='AMW_ORG_REV_ETTY'

Line 1178: ,eng_subject_entities ese

1174: ,ESE.SUBJECT_ID
1175: INTO L_DELETE_LINE_TYPE_ID
1176: ,L_DELETE_CHANGE_SUBJECT_ID
1177: from eng_change_order_types ecot
1178: ,eng_subject_entities ese
1179: where ecot.change_mgmt_type_code='AMW_PROCESS_ORG_APPROVAL'
1180: and ecot.SUBJECT_ID=ese.subject_id
1181: AND ESE.ENTITY_NAME='AMW_ORG_LINE_DEL_CTRL_ETTY'
1182: AND ESE.PARENT_ENTITY_NAME='AMW_ORG_REV_ETTY'

Line 1401: ,eng_subject_entities ese

1397: BEGIN
1398: select ecot.change_order_type_id
1399: INTO L_LINE_TYPE_ID
1400: from eng_change_order_types ecot
1401: ,eng_subject_entities ese
1402: where ecot.change_mgmt_type_code=p_change_mgmt_type_code
1403: and ecot.SUBJECT_ID=ese.subject_id
1404: AND ESE.ENTITY_NAME=p_entity_name
1405: AND ESE.PARENT_ENTITY_NAME=p_parent_entity_name