APPS.INV_ITEM_STATUS_CP dependencies on MTL_PENDING_ITEM_STATUS

Line 505: UPDATE mtl_pending_item_status

501: WHERE p1.organization_id = p_Org_Id
502: AND p1.master_organization_id = p2.master_organization_id)));
503:
504: /* End Bug 3713912 */
505: UPDATE mtl_pending_item_status
506: SET pending_flag = 'N' ,
507: implemented_date = SYSDATE ,
508: request_id = G_REQUEST_ID,
509: program_application_id = G_PROG_APPID,

Line 601: FROM mtl_pending_item_status pis,

597: IS
598: SELECT pis.status_code,
599: pis.inventory_item_id,
600: pis.organization_id
601: FROM mtl_pending_item_status pis,
602: mtl_item_status pit
603: WHERE pis.effective_date <= sysdate
604: AND pis.pending_flag = 'Y'
605: AND pis.inventory_item_id = nvl(cp_item_id,pis.inventory_item_id)

Line 621: FROM mtl_pending_item_status pis,

617: IS
618: SELECT pis.status_code,
619: pis.inventory_item_id,
620: pis.organization_id
621: FROM mtl_pending_item_status pis,
622: mtl_item_status pit
623: WHERE pis.effective_date <= sysdate
624: AND pis.pending_flag = 'Y'
625: AND pis.inventory_item_id = nvl(cp_item_id,pis.inventory_item_id)

Line 646: l_status_code mtl_pending_item_status.status_code%TYPE;

642: SELECT status_control_code
643: FROM mtl_item_attributes
644: WHERE attribute_name = cp_attrib_name;
645:
646: l_status_code mtl_pending_item_status.status_code%TYPE;
647: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
648: l_org_id mtl_pending_item_status.organization_id%TYPE;
649: l_control_level mtl_item_attributes.control_level%TYPE;
650: l_done BOOLEAN := FALSE;

Line 647: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;

643: FROM mtl_item_attributes
644: WHERE attribute_name = cp_attrib_name;
645:
646: l_status_code mtl_pending_item_status.status_code%TYPE;
647: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
648: l_org_id mtl_pending_item_status.organization_id%TYPE;
649: l_control_level mtl_item_attributes.control_level%TYPE;
650: l_done BOOLEAN := FALSE;
651: l_counter NUMBER := 1;

Line 648: l_org_id mtl_pending_item_status.organization_id%TYPE;

644: WHERE attribute_name = cp_attrib_name;
645:
646: l_status_code mtl_pending_item_status.status_code%TYPE;
647: l_item_id mtl_pending_item_status.inventory_item_id%TYPE;
648: l_org_id mtl_pending_item_status.organization_id%TYPE;
649: l_control_level mtl_item_attributes.control_level%TYPE;
650: l_done BOOLEAN := FALSE;
651: l_counter NUMBER := 1;
652: