DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_ITEM_REVISIONS

Line 83: FROM Mtl_Item_Revisions

79: l_item_rev VARCHAR2(3) := NULL;
80:
81: CURSOR ITEM_REV IS
82: SELECT revision
83: FROM Mtl_Item_Revisions
84: WHERE inventory_item_id = p_revised_item_id
85: AND organization_id = p_organization_id
86: ORDER BY effectivity_date desc, revision desc;
87:

Line 259: FROM MTL_ITEM_REVISIONS

255: l_current_revision VARCHAR2(3) := NULL;
256:
257: CURSOR NO_ECO_ITEM_REV IS
258: SELECT REVISION
259: FROM MTL_ITEM_REVISIONS
260: WHERE INVENTORY_ITEM_ID = p_revised_item_id
261: AND ORGANIZATION_ID = p_organization_id
262: AND EFFECTIVITY_DATE <= p_revision_date
263: AND IMPLEMENTATION_DATE IS NOT NULL

Line 315: FROM MTL_ITEM_REVISIONS

311: l_Pending_Rev NUMBER := 0;
312: l_rev_sequence NUMBER;
313:
314: CURSOR c1 IS SELECT change_notice
315: FROM MTL_ITEM_REVISIONS
316: WHERE inventory_item_id = p_revised_item_id
317: AND organization_id = p_organization_id
318: AND revision = p_new_item_revision
319: AND revised_item_sequence_id <>

Line 325: FROM MTL_ITEM_REVISIONS

321: revised_item_sequence_id+99)
322: AND implementation_date is null;
323:
324: CURSOR c2 IS SELECT 1
325: FROM MTL_ITEM_REVISIONS
326: WHERE inventory_item_id = p_revised_item_id
327: AND organization_id = p_organization_id
328: AND revision = p_new_item_revision
329: AND implementation_date is not null;

Line 414: FROM mtl_item_revisions r

410:
411: CURSOR check_high_date_low_rev
412: IS
413: SELECT 1
414: FROM mtl_item_revisions r
415: WHERE r.inventory_item_id = p_revised_item_id
416: AND r.organization_id = p_organization_id
417: AND NVL(r.revised_item_sequence_id, -1) <> NVL(p_rev_item_seq_id, -2)
418: AND ((r.effectivity_date >= p_scheduled_date and r.revision < p_new_item_revision)

Line 460: FROM mtl_item_revisions r

456:
457: CURSOR sheduled_date_from_revision
458: IS
459: SELECT 1
460: FROM mtl_item_revisions r
461: WHERE r.inventory_item_id = p_revised_item_id
462: AND r.organization_id = p_organization_id
463: AND r.effectivity_date >= p_scheduled_date
464: AND r.revision = p_from_item_revision;

Line 524: FROM MTL_ITEM_REVISIONS

520: l_Pending_Rev NUMBER := 0;
521: l_rev_sequence NUMBER;
522:
523: CURSOR c1 IS SELECT change_notice
524: FROM MTL_ITEM_REVISIONS
525: WHERE inventory_item_id = p_revised_item_id
526: AND organization_id = p_organization_id
527: AND revision = p_new_item_revision
528: AND implementation_date is null;

Line 531: FROM MTL_ITEM_REVISIONS

527: AND revision = p_new_item_revision
528: AND implementation_date is null;
529:
530: CURSOR c2 IS SELECT 1
531: FROM MTL_ITEM_REVISIONS
532: WHERE inventory_item_id = p_revised_item_id
533: AND organization_id = p_organization_id
534: AND revision = p_new_item_revision
535: AND implementation_date is not null;

Line 6222: l_Old_Phase_Id mtl_item_revisions_b.current_phase_id%TYPE;

6218: l_phase_change_code VARCHAR2(30) :='REVISE';
6219: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
6220: l_Lifecycle_Id NUMBER;
6221: l_policy_code VARCHAR2(100);
6222: l_Old_Phase_Id mtl_item_revisions_b.current_phase_id%TYPE;
6223: l_Error_Code NUMBER;
6224: l_Msg_Data VARCHAR2(2000);
6225: l_api_version CONSTANT NUMBER := 1.0;
6226: l_project_id NUMBER :=NULL;

Line 7108: l_from_item_revision mtl_item_revisions.revision%TYPE;

7104: -- init the following
7105: l_org_code VARCHAR2(3);
7106: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
7107: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
7108: l_from_item_revision mtl_item_revisions.revision%TYPE;
7109: l_completion_location_name VARCHAR2(1);
7110: l_from_work_order VARCHAR2(1);
7111: l_to_work_order VARCHAR2(1);
7112: l_msg_data VARCHAR2(32000);