APPS.INVPPRCI dependencies on MTL_RELATED_ITEMS

Line 1140: /* Copy related items into MTL_RELATED_ITEMS table */

1136: (MP1.ORGANIZATION_ID = validation_org ));
1137:
1138:
1139:
1140: /* Copy related items into MTL_RELATED_ITEMS table */
1141: table_name := 'MTL_RELATED_ITEMS';
1142: insert into MTL_RELATED_ITEMS
1143: (
1144: inventory_item_id,

Line 1141: table_name := 'MTL_RELATED_ITEMS';

1137:
1138:
1139:
1140: /* Copy related items into MTL_RELATED_ITEMS table */
1141: table_name := 'MTL_RELATED_ITEMS';
1142: insert into MTL_RELATED_ITEMS
1143: (
1144: inventory_item_id,
1145: related_item_id,

Line 1142: insert into MTL_RELATED_ITEMS

1138:
1139:
1140: /* Copy related items into MTL_RELATED_ITEMS table */
1141: table_name := 'MTL_RELATED_ITEMS';
1142: insert into MTL_RELATED_ITEMS
1143: (
1144: inventory_item_id,
1145: related_item_id,
1146: relationship_type_id,

Line 1173: from mtl_related_items_interface rii,

1169: prg_appid, /* program_application_id */
1170: prg_id, /* program_id */
1171: SYSDATE, /* program_update_date */
1172: rii.organization_id
1173: from mtl_related_items_interface rii,
1174: mtl_system_items_interface si
1175: where rii.inventory_item_id = si.inventory_item_id
1176: and rii.organization_id = si.organization_id
1177: and rii.related_item_id is not NULL

Line 1183: insert into MTL_RELATED_ITEMS

1179: and rii.reciprocal_flag is not NULL
1180: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
1181:
1182:
1183: insert into MTL_RELATED_ITEMS
1184: (
1185: inventory_item_id,
1186: related_item_id,
1187: relationship_type_id,

Line 1215: from mtl_related_items ri,

1211: prg_appid, /* program_application_id */
1212: prg_id, /* program_id */
1213: SYSDATE, /* program_update_date */
1214: ri.organization_id
1215: from mtl_related_items ri,
1216: mtl_system_items_interface si
1217: where ri.inventory_item_id = si.copy_item_id
1218: and ri.organization_id = si.organization_id
1219: and not exists ( select NULL

Line 1220: from mtl_related_items_interface rii

1216: mtl_system_items_interface si
1217: where ri.inventory_item_id = si.copy_item_id
1218: and ri.organization_id = si.organization_id
1219: and not exists ( select NULL
1220: from mtl_related_items_interface rii
1221: where rii.inventory_item_id = si.inventory_item_id
1222: and rii.organization_id = si.organization_id
1223: and rii.related_item_id is not NULL
1224: and rii.relationship_type_id is not NULL

Line 1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';

1621: where si.inventory_item_id = ci2.inventory_item_id
1622: and si.organization_id = ci2.organization_id
1623: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1624:
1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si

Line 1626: delete from MTL_RELATED_ITEMS_INTERFACE ri

1622: and si.organization_id = ci2.organization_id
1623: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
1624:
1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si
1630: where si.inventory_item_id = ri2.inventory_item_id

Line 1628: from MTL_RELATED_ITEMS_INTERFACE ri2,

1624:
1625: table_name := 'MTL_RELATED_ITEMS_INTERFACE';
1626: delete from MTL_RELATED_ITEMS_INTERFACE ri
1627: where ri.rowid in ( select ri2.rowid
1628: from MTL_RELATED_ITEMS_INTERFACE ri2,
1629: MTL_SYSTEM_ITEMS_INTERFACE si
1630: where si.inventory_item_id = ri2.inventory_item_id
1631: and si.organization_id = ri2.organization_id
1632: and si.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));