APPS.EAM_ACTIVITY_PUB dependencies on MTL_SYSTEM_ITEMS

Line 576: from mtl_system_items

572:
573: -- sraval: added for Direct Items 11.5.10
574: select stock_enabled_flag,list_price_per_unit
575: into l_stock_enabled_flag,l_list_price_per_unit
576: from mtl_system_items
577: where inventory_item_id = l_wip_requirement_row.inventory_item_id
578: and organization_id = l_wip_requirement_row.organization_id;
579:
580: if l_stock_enabled_flag = 'N' then

Line 1081: UPDATE mtl_system_items

1077: l_x_master_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1078: l_x_master_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1079:
1080: BEGIN
1081: UPDATE mtl_system_items
1082: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1083: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1084: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1085: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 1104: UPDATE mtl_system_items

1100: l_x_curr_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1101: l_x_curr_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1102:
1103: BEGIN
1104: UPDATE mtl_system_items
1105: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1106: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1107: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1108: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 1510: UPDATE mtl_system_items

1506: l_x_master_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1507: l_x_master_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1508:
1509: BEGIN
1510: UPDATE mtl_system_items
1511: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1512: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1513: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1514: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 1533: UPDATE mtl_system_items

1529: l_x_curr_item_rec.EAM_ACT_SHUTDOWN_STATUS := p_shutdown_type_code;
1530: l_x_curr_item_rec.EAM_ACT_NOTIFICATION_FLAG := p_notification_req_flag;
1531:
1532: BEGIN
1533: UPDATE mtl_system_items
1534: SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
1535: EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
1536: EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
1537: EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,

Line 2987: FROM mtl_system_items_b

2983: l_item_rec.description, l_item_rec.eam_activity_type_code,
2984: l_item_rec.eam_activity_cause_code, l_item_rec.eam_activity_source_code,
2985: l_item_rec.eam_act_notification_flag, l_item_rec.eam_act_shutdown_status,
2986: l_item_rec.eam_item_type
2987: FROM mtl_system_items_b
2988: WHERE organization_id = l_master_organization_id
2989: AND inventory_item_id = p_activity_id;
2990:
2991: -- Validate org id and org code

Line 3079: FROM mtl_system_items_b

3075: l_item_rec.description, l_item_rec.eam_activity_type_code,
3076: l_item_rec.eam_activity_cause_code, l_item_rec.eam_activity_source_code,
3077: l_item_rec.eam_act_notification_flag, l_item_rec.eam_act_shutdown_status,
3078: l_item_rec.eam_item_type
3079: FROM mtl_system_items_b
3080: WHERE inventory_item_id = p_activity_id
3081: AND ROWNUM = 1;
3082:
3083: l_item_rec.organization_id := p_org_id;