APPS.INV_ITEM_GRP dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 1039: FROM mtl_item_revisions_interface

1035:
1036: CURSOR c_mtl_item_rev_interface
1037: IS
1038: SELECT transaction_id
1039: FROM mtl_item_revisions_interface
1040: WHERE organization_id = X_organization_id
1041: AND inventory_item_id = X_inventory_item_id
1042: AND revision = X_revision;
1043: */

Line 4266: l_default_revision mtl_item_revisions_interface.revision%TYPE;

4262:
4263: p_Upd_Null_CHAR VARCHAR2(1);
4264: p_Upd_Null_NUM NUMBER;
4265: p_Upd_Null_DATE DATE;
4266: l_default_revision mtl_item_revisions_interface.revision%TYPE;
4267: l_temp_integer INTEGER;
4268: l_item_number mtl_item_revisions_interface.item_number%TYPE := NULL;
4269: l_item_id mtl_item_revisions_interface.inventory_item_id%TYPE := NULL;
4270: l_error_text VARCHAR2(1000);

Line 4268: l_item_number mtl_item_revisions_interface.item_number%TYPE := NULL;

4264: p_Upd_Null_NUM NUMBER;
4265: p_Upd_Null_DATE DATE;
4266: l_default_revision mtl_item_revisions_interface.revision%TYPE;
4267: l_temp_integer INTEGER;
4268: l_item_number mtl_item_revisions_interface.item_number%TYPE := NULL;
4269: l_item_id mtl_item_revisions_interface.inventory_item_id%TYPE := NULL;
4270: l_error_text VARCHAR2(1000);
4271:
4272: BEGIN

Line 4269: l_item_id mtl_item_revisions_interface.inventory_item_id%TYPE := NULL;

4265: p_Upd_Null_DATE DATE;
4266: l_default_revision mtl_item_revisions_interface.revision%TYPE;
4267: l_temp_integer INTEGER;
4268: l_item_number mtl_item_revisions_interface.item_number%TYPE := NULL;
4269: l_item_id mtl_item_revisions_interface.inventory_item_id%TYPE := NULL;
4270: l_error_text VARCHAR2(1000);
4271:
4272: BEGIN
4273:

Line 4303: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE (

4299: p_Upd_Null_NUM := NULL;
4300: p_Upd_Null_DATE := NULL;
4301: END IF;
4302:
4303: INSERT INTO MTL_ITEM_REVISIONS_INTERFACE (
4304: INVENTORY_ITEM_ID
4305: ,ORGANIZATION_ID
4306: ,REVISION
4307: ,EFFECTIVITY_DATE