APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on ENG_ENGINEERING_CHANGES

Line 76: FROM eng_engineering_changes

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

Line 3347: FROM eng_engineering_changes

3343: RAISE FND_API.g_exc_unexpected_error;
3344: END IF;
3345:
3346: SELECT change_id ,change_notice INTO x_out.change_id,x_out.change_notice
3347: FROM eng_engineering_changes
3348: WHERE change_notice = l_eco_rec.eco_name
3349: AND organization_id = l_organization_id;
3350:
3351: x_out.organization_code := p_change_order.organization_code;

Line 4197: eng_engineering_changes eec

4193: ,eec.implementation_date
4194: ,eec.cancellation_date
4195: ,ecot.type_name
4196: FROM
4197: eng_engineering_changes eec
4198: ,mtl_parameters mp
4199: ,eng_change_statuses_vl ecsv
4200: ,eng_ecn_approval_lists eeal
4201: ,hz_parties hp

Line 4243: ,eng_engineering_changes eec

4239: ,eec.change_mgmt_type_code
4240: ,ecor.original_system_reference
4241: FROM
4242: eng_change_order_revisions ecor
4243: ,eng_engineering_changes eec
4244: WHERE
4245: ecor.change_id = eec.change_id AND
4246: ecor.change_id = p_change_id;
4247:

Line 5100: FROM eng_engineering_changes ec, mtl_parameters mp

5096: IF p_eco_tbl IS NOT NULL AND p_eco_tbl.COUNT>0 THEN
5097: FOR i in p_eco_tbl.FIRST..p_eco_tbl.LAST LOOP
5098: l_org_code := NULL;
5099: SELECT mp.organization_code INTO l_org_code
5100: FROM eng_engineering_changes ec, mtl_parameters mp
5101: WHERE ec.change_id = p_eco_tbl(i).change_id
5102: AND ec.organization_id = mp.organization_id;
5103: IF l_org_tbl IS NOT NULL AND l_org_tbl.COUNT>0 THEN
5104: FOR j in l_org_tbl.FIRST..l_org_tbl.LAST LOOP

Line 5154: FROM eng_engineering_changes

5150: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
5151: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
5152: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
5153: SELECT change_id
5154: FROM eng_engineering_changes
5155: WHERE change_notice = p_chg_notice;
5156: BEGIN
5157: x_return_status := FND_API.g_ret_sts_success;
5158: l_eco_output_tbl :=inv_ebi_change_id_obj_tbl();

Line 5175: FROM eng_engineering_changes

5171: FOR i in l_eco_tbl.FIRST..l_eco_tbl.LAST LOOP
5172: BEGIN
5173: FND_MSG_PUB.initialize();
5174: SELECT COUNT(1) into l_entity_exist
5175: FROM eng_engineering_changes
5176: WHERE change_notice = l_eco_tbl(i);
5177: IF l_entity_exist>0 THEN
5178: l_entity_count := l_entity_count +1;
5179: l_valid_eco_tbl.EXTEND();

Line 5256: FROM eng_engineering_changes

5252: l_chg_id := NULL;
5253: BEGIN
5254: SELECT change_id
5255: INTO l_chg_id
5256: FROM eng_engineering_changes
5257: WHERE change_notice = l_valid_eco_tbl(i)
5258: AND organization_id = l_org_id;
5259: EXCEPTION
5260: WHEN OTHERS THEN

Line 5345: FROM eng_engineering_changes eec

5341: CURSOR c_get_eco_chgid IS
5342: SELECT inv_ebi_change_id_obj(eci.change_id, 'Y')
5343: FROM(
5344: SELECT eec.change_id
5345: FROM eng_engineering_changes eec
5346: WHERE eec.last_update_date <> eec.creation_date
5347: AND eec.last_update_date >= l_from_date
5348: AND eec.last_update_date <= l_to_date
5349: UNION