APPS.EAM_ACTIVITY_PUB dependencies on MTL_SYSTEM_ITEMS

Line 602: from mtl_system_items

598:
599: -- sraval: added for Direct Items 11.5.10
600: select stock_enabled_flag,list_price_per_unit
601: into l_stock_enabled_flag,l_list_price_per_unit
602: from mtl_system_items
603: where inventory_item_id = l_wip_requirement_row.inventory_item_id
604: and organization_id = l_wip_requirement_row.organization_id;
605:
606: if l_stock_enabled_flag = 'N' then

Line 1112: UPDATE mtl_system_items

1108: l_x_master_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1109: l_x_master_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1110:
1111: BEGIN
1112: UPDATE mtl_system_items
1113: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1114: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1115: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1116: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 1135: UPDATE mtl_system_items

1131: l_x_curr_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1132: l_x_curr_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1133:
1134: BEGIN
1135: UPDATE mtl_system_items
1136: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1137: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1138: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1139: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 1541: UPDATE mtl_system_items

1537: l_x_master_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1538: l_x_master_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1539:
1540: BEGIN
1541: UPDATE mtl_system_items
1542: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1543: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1544: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1545: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 1564: UPDATE mtl_system_items

1560: l_x_curr_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1561: l_x_curr_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1562:
1563: BEGIN
1564: UPDATE mtl_system_items
1565: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1566: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1567: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1568: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 3018: FROM mtl_system_items_b

3014: l_item_rec.description, l_item_rec.eam_activity_type_code,
3015: l_item_rec.eam_activity_cause_code, l_item_rec.eam_activity_source_code,
3016: l_item_rec.eam_act_notification_flag, l_item_rec.eam_act_shutdown_status,
3017: l_item_rec.eam_item_type
3018: FROM mtl_system_items_b
3019: WHERE organization_id = l_master_organization_id
3020: AND inventory_item_id = p_activity_id;
3021:
3022: -- Validate org id and org code

Line 3110: FROM mtl_system_items_b

3106: l_item_rec.description, l_item_rec.eam_activity_type_code,
3107: l_item_rec.eam_activity_cause_code, l_item_rec.eam_activity_source_code,
3108: l_item_rec.eam_act_notification_flag, l_item_rec.eam_act_shutdown_status,
3109: l_item_rec.eam_item_type
3110: FROM mtl_system_items_b
3111: WHERE inventory_item_id = p_activity_id
3112: AND ROWNUM = 1;
3113:
3114: l_item_rec.organization_id := p_org_id;