APPS.AHL_RM_MATERIAL_AS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1461: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

1457: x_return_status OUT NOCOPY VARCHAR2
1458: )
1459: IS
1460:
1461: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
1462: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
1463: IS
1464: SELECT DISTINCT MI.comms_nl_trackable_flag
1465: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

Line 1462: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

1458: )
1459: IS
1460:
1461: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
1462: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
1463: IS
1464: SELECT DISTINCT MI.comms_nl_trackable_flag
1465: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
1466: WHERE MP.organization_id = MI.organization_id

Line 1465: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

1461: CURSOR get_comms_nl_trackable_flag ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
1462: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
1463: IS
1464: SELECT DISTINCT MI.comms_nl_trackable_flag
1465: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
1466: WHERE MP.organization_id = MI.organization_id
1467: AND MI.inventory_item_id = c_inventory_item_id
1468: AND MI.organization_id = c_inventory_org_id
1469: AND MI.enabled_flag = 'Y'

Line 1473: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;

1469: AND MI.enabled_flag = 'Y'
1470: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
1471: AND NVL( MI.end_date_active, SYSDATE );
1472:
1473: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
1474: BEGIN
1475: x_return_status := FND_API.G_RET_STS_SUCCESS;
1476:
1477: IF ( p_material_req_rec.dml_operation <> 'D' ) THEN

Line 2037: FROM MTL_SYSTEM_ITEMS_KFV MTL

2033:
2034: CURSOR get_item_number ( c_inventory_item_id NUMBER, c_inventory_master_org_id NUMBER )
2035: IS
2036: SELECT mtl.concatenated_segments
2037: FROM MTL_SYSTEM_ITEMS_KFV MTL
2038: WHERE
2039: mtl.ORGANIZATION_ID(+) = c_inventory_item_id AND
2040: mtl.inventory_item_id(+) = c_inventory_master_org_id;
2041: