APPS.OE_VALIDATE_LINE dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1347: org_organization_definitions org

1343:
1344: SELECT null
1345: INTO l_dummy
1346: FROM mtl_system_items_b msi,
1347: org_organization_definitions org
1348: WHERE msi.inventory_item_id = p_inventory_item_id
1349: AND org.organization_id= msi.organization_id
1350: AND msi.customer_order_enabled_flag =
1351: DECODE(l_validate, 'Y', 'Y',

Line 1359: org_organization_definitions org

1355: ELSE
1356: SELECT null
1357: INTO l_dummy
1358: FROM mtl_system_items_b msi,
1359: org_organization_definitions org
1360: WHERE msi.inventory_item_id = p_inventory_item_id
1361: AND org.organization_id= msi.organization_id
1362: AND msi.customer_order_enabled_flag =
1363: DECODE(l_validate, 'Y', 'Y',

Line 1462: org_organization_definitions org

1458: THEN
1459: SELECT null
1460: INTO l_dummy
1461: FROM mtl_system_items_b msi,
1462: org_organization_definitions org
1463: WHERE msi.inventory_item_id = p_inventory_item_id
1464: AND org.organization_id= msi.organization_id
1465: AND msi.internal_order_enabled_flag = 'Y'
1466: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1476: org_organization_definitions org

1472: THEN
1473: SELECT null
1474: INTO l_dummy
1475: FROM mtl_system_items_b msi,
1476: org_organization_definitions org
1477: WHERE msi.inventory_item_id = p_inventory_item_id
1478: AND org.organization_id= msi.organization_id
1479: AND sysdate <= nvl( org.disable_date, sysdate)
1480: AND org.organization_id= p_ship_from_org_id

Line 1492: org_organization_definitions org

1488: --Commented for bug 4343544 start
1489: /*SELECT null
1490: INTO l_dummy
1491: FROM mtl_system_items_b msi,
1492: org_organization_definitions org
1493: WHERE msi.inventory_item_id = p_inventory_item_id
1494: AND org.organization_id= msi.organization_id
1495: AND sysdate <= nvl( org.disable_date, sysdate)
1496: AND org.organization_id= p_ship_from_org_id

Line 1507: org_organization_definitions org

1503: if g_cust_ord_enabled_flag='Y' then
1504: SELECT null
1505: INTO l_dummy
1506: FROM mtl_system_items_b msi,
1507: org_organization_definitions org
1508: WHERE msi.inventory_item_id = p_inventory_item_id
1509: AND org.organization_id= msi.organization_id
1510: AND sysdate <= nvl( org.disable_date, sysdate)
1511: AND org.organization_id= p_ship_from_org_id

Line 1518: org_organization_definitions org

1514: else
1515: SELECT null
1516: INTO l_dummy
1517: FROM mtl_system_items_b msi,
1518: org_organization_definitions org
1519: WHERE msi.inventory_item_id = p_inventory_item_id
1520: AND org.organization_id= msi.organization_id
1521: AND sysdate <= nvl( org.disable_date, sysdate)
1522: AND org.organization_id= p_ship_from_org_id

Line 1530: org_organization_definitions org

1526: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1527: SELECT null
1528: INTO l_dummy
1529: FROM mtl_system_items_b msi,
1530: org_organization_definitions org
1531: WHERE msi.inventory_item_id = p_inventory_item_id
1532: AND org.organization_id= msi.organization_id
1533: AND msi.customer_order_enabled_flag = 'Y'
1534: AND sysdate <= nvl( org.disable_date, sysdate)

Line 2874: org_organization_definitions org

2870:
2871: SELECT purchasing_enabled_flag
2872: INTO l_purchasing_enabled_flag
2873: FROM mtl_system_items msi,
2874: org_organization_definitions org
2875: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2876: AND org.organization_id= msi.organization_id
2877: AND sysdate <= nvl( org.disable_date, sysdate)
2878: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,

Line 2887: org_organization_definitions org

2883: ELSE
2884: SELECT purchasing_enabled_flag
2885: INTO l_purchasing_enabled_flag
2886: FROM mtl_system_items msi,
2887: org_organization_definitions org
2888: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2889: AND org.organization_id= msi.organization_id
2890: AND sysdate <= nvl( org.disable_date, sysdate)
2891: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,