APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_ENGINEERING_CHANGES

Line 78: FROM eng_engineering_changes

74: l_pkdata.extend(1);
75: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('CHANGE_ID',p_change_id);
76:
77: SELECT change_order_type_id INTO l_change_order_type_id
78: FROM eng_engineering_changes
79: WHERE change_id = p_change_id;
80:
81: l_application_id:= INV_EBI_UTIL.get_application_id(
82: p_application_short_name => 'ENG'

Line 4824: FROM eng_engineering_changes

4820: RAISE FND_API.g_exc_unexpected_error;
4821: END IF;
4822:
4823: SELECT change_id ,change_notice INTO x_out.change_id,x_out.change_notice
4824: FROM eng_engineering_changes
4825: WHERE change_notice = l_eco_rec.eco_name
4826: AND organization_id = l_organization_id;
4827:
4828: x_out.organization_code := p_change_order.organization_code;

Line 5140: eng_engineering_changes eec

5136: ,eec.implementation_date
5137: ,eec.cancellation_date
5138: ,ecot.type_name
5139: FROM
5140: eng_engineering_changes eec
5141: ,mtl_parameters mp
5142: ,eng_change_statuses_vl ecsv
5143: ,eng_ecn_approval_lists eeal
5144: ,hz_parties hp

Line 5186: ,eng_engineering_changes eec

5182: ,eec.change_mgmt_type_code
5183: ,ecor.original_system_reference
5184: FROM
5185: eng_change_order_revisions ecor
5186: ,eng_engineering_changes eec
5187: WHERE
5188: ecor.change_id = eec.change_id AND
5189: ecor.change_id = p_change_id;
5190:

Line 6051: FROM eng_engineering_changes ec, mtl_parameters mp

6047: IF p_eco_tbl IS NOT NULL AND p_eco_tbl.COUNT>0 THEN
6048: FOR i in p_eco_tbl.FIRST..p_eco_tbl.LAST LOOP
6049: l_org_code := NULL;
6050: SELECT mp.organization_code INTO l_org_code
6051: FROM eng_engineering_changes ec, mtl_parameters mp
6052: WHERE ec.change_id = p_eco_tbl(i).change_id
6053: AND ec.organization_id = mp.organization_id;
6054: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT>0 THEN
6055: FOR j in l_org_tbl.FIRST..l_org_tbl.LAST LOOP

Line 6112: FROM eng_engineering_changes

6108: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6110: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
6111: SELECT change_id
6112: FROM eng_engineering_changes
6113: WHERE change_notice = p_chg_notice;
6114: BEGIN
6115: x_return_status := FND_API.g_ret_sts_success;
6116: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco');

Line 6136: FROM eng_engineering_changes

6132: FOR i in l_eco_tbl.FIRST..l_eco_tbl.LAST LOOP
6133: BEGIN
6134: FND_MSG_PUB.initialize();
6135: SELECT COUNT(1) into l_entity_exist
6136: FROM eng_engineering_changes
6137: WHERE change_notice = l_eco_tbl(i);
6138: IF l_entity_exist>0 THEN
6139: l_entity_count := l_entity_count +1;
6140: l_valid_eco_tbl.EXTEND();

Line 6217: FROM eng_engineering_changes

6213: l_chg_id := NULL;
6214: BEGIN
6215: SELECT change_id
6216: INTO l_chg_id
6217: FROM eng_engineering_changes
6218: WHERE change_notice = l_valid_eco_tbl(i)
6219: AND organization_id = l_org_id;
6220: EXCEPTION
6221: WHEN OTHERS THEN

Line 6314: FROM eng_engineering_changes eec

6310: CURSOR c_get_eco_chgid IS
6311: SELECT inv_ebi_change_id_obj(eci.change_id, 'Y')
6312: FROM(
6313: SELECT eec.change_id
6314: FROM eng_engineering_changes eec
6315: WHERE eec.last_update_date <> eec.creation_date
6316: AND eec.last_update_date >= l_from_date
6317: AND eec.last_update_date <= l_to_date
6318: UNION