APPS.ENG_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS

Line 85: UPDATE MTL_SYSTEM_ITEMS

81: IF (X_eng_item_id = X_mfg_item_id) THEN
82:
83: X_stmt_num := 100;
84: BEGIN
85: UPDATE MTL_SYSTEM_ITEMS
86: SET ENG_ITEM_FLAG = 'N',
87: --DESCRIPTION = X_mfg_description,
88: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),
89:

Line 133: UPDATE MTL_SYSTEM_ITEMS

129:
130: IF (X_master_org <> X_org_id) THEN
131: X_stmt_num := 102;
132: BEGIN
133: UPDATE MTL_SYSTEM_ITEMS
134: SET ENG_ITEM_FLAG = 'N',
135: --DESCRIPTION = X_mfg_description,
136: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')),
137:

Line 186: -- Copy rows for MTL_SYSTEM_ITEMS

182: -- item id has not changed
183:
184: IF (X_eng_item_id <> X_mfg_item_id) THEN
185:
186: -- Copy rows for MTL_SYSTEM_ITEMS
187:
188: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
189: X_org_id,
190: X_eng_item_id,

Line 188: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,

184: IF (X_eng_item_id <> X_mfg_item_id) THEN
185:
186: -- Copy rows for MTL_SYSTEM_ITEMS
187:
188: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
189: X_org_id,
190: X_eng_item_id,
191: X_mfg_item_id,
192: -1,

Line 331: -- Copy rows for MTL_SYSTEM_ITEMS for the master org

327: -- organization. If not, it needs to be created.
328:
329: IF (X_master_org <> X_org_id) THEN
330:
331: -- Copy rows for MTL_SYSTEM_ITEMS for the master org
332:
333: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
334: X_master_org,
335: X_eng_item_id,

Line 333: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,

329: IF (X_master_org <> X_org_id) THEN
330:
331: -- Copy rows for MTL_SYSTEM_ITEMS for the master org
332:
333: ENG_COPY_TABLE_ROWS_PKG.C_MTL_SYSTEM_ITEMS(X_org_id,
334: X_master_org,
335: X_eng_item_id,
336: X_mfg_item_id,
337: -1,

Line 574: from bom_components_b bcb, mtl_system_items_b msib

570:
571:
572: cursor comp_rows(bill_id IN NUMBER) is
573: select msib.bom_item_type, msib.replenish_to_order_flag, bcb.optional
574: from bom_components_b bcb, mtl_system_items_b msib
575: where bcb.bill_sequence_id = bill_id
576: and msib.inventory_item_id = bcb.component_item_id
577: and msib.organization_id = bcb.pk2_value;
578:

Line 590: from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;

586:
587: BEGIN
588:
589: select msib.bom_item_type, msib.pick_components_flag into l_parent_BIT, l_PTO_flag
590: from mtl_system_items_b msib where inventory_item_id = X_eng_item_id and organization_id = X_org_id;
591:
592: for bill in all_bills(X_org_id, X_eng_item_id,
593: X_designator_option, X_alt_bom_designator) loop
594:

Line 646: UPDATE MTL_SYSTEM_ITEMS

642:
643: X_GTIN_ST_TYPE_ID := Get_GTIN_Structure_Type_Id;
644:
645: BEGIN
646: UPDATE MTL_SYSTEM_ITEMS
647: SET ENG_ITEM_FLAG = 'N',
648: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
649: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
650: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */

Line 685: UPDATE MTL_SYSTEM_ITEMS

681:
682: X_stmt_num := 200;
683:
684: BEGIN
685: UPDATE MTL_SYSTEM_ITEMS
686: SET ENG_ITEM_FLAG = 'N',
687: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
688: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
689: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */

Line 743: UPDATE MTL_SYSTEM_ITEMS

739:
740: IF (X_master_org <> X_org_id) THEN
741: X_stmt_num := 200;
742: BEGIN
743: UPDATE MTL_SYSTEM_ITEMS
744: SET ENG_ITEM_FLAG = 'N',
745: LAST_UPDATE_LOGIN = to_number(Fnd_Profile.Value('LOGIN_ID')), /* for bug 9868364 */
746: LAST_UPDATED_BY = to_number(Fnd_Profile.Value('USER_ID')), /* for bug 9868364 */
747: LAST_UPDATE_DATE = SYSDATE /* for bug 9701210 */