APPS.OE_VALIDATE_LINE dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 1323: org_organization_definitions org

1319:
1320: SELECT null
1321: INTO l_dummy
1322: FROM mtl_system_items_b msi,
1323: org_organization_definitions org
1324: WHERE msi.inventory_item_id = p_inventory_item_id
1325: AND org.organization_id= msi.organization_id
1326: AND msi.customer_order_enabled_flag =
1327: DECODE(l_validate, 'Y', 'Y',

Line 1335: org_organization_definitions org

1331: ELSE
1332: SELECT null
1333: INTO l_dummy
1334: FROM mtl_system_items_b msi,
1335: org_organization_definitions org
1336: WHERE msi.inventory_item_id = p_inventory_item_id
1337: AND org.organization_id= msi.organization_id
1338: AND msi.customer_order_enabled_flag =
1339: DECODE(l_validate, 'Y', 'Y',

Line 1438: org_organization_definitions org

1434: THEN
1435: SELECT null
1436: INTO l_dummy
1437: FROM mtl_system_items_b msi,
1438: org_organization_definitions org
1439: WHERE msi.inventory_item_id = p_inventory_item_id
1440: AND org.organization_id= msi.organization_id
1441: AND msi.internal_order_enabled_flag = 'Y'
1442: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1452: org_organization_definitions org

1448: THEN
1449: SELECT null
1450: INTO l_dummy
1451: FROM mtl_system_items_b msi,
1452: org_organization_definitions org
1453: WHERE msi.inventory_item_id = p_inventory_item_id
1454: AND org.organization_id= msi.organization_id
1455: AND sysdate <= nvl( org.disable_date, sysdate)
1456: AND org.organization_id= p_ship_from_org_id

Line 1468: org_organization_definitions org

1464: --Commented for bug 4343544 start
1465: /*SELECT null
1466: INTO l_dummy
1467: FROM mtl_system_items_b msi,
1468: org_organization_definitions org
1469: WHERE msi.inventory_item_id = p_inventory_item_id
1470: AND org.organization_id= msi.organization_id
1471: AND sysdate <= nvl( org.disable_date, sysdate)
1472: AND org.organization_id= p_ship_from_org_id

Line 1483: org_organization_definitions org

1479: if g_cust_ord_enabled_flag='Y' then
1480: SELECT null
1481: INTO l_dummy
1482: FROM mtl_system_items_b msi,
1483: org_organization_definitions org
1484: WHERE msi.inventory_item_id = p_inventory_item_id
1485: AND org.organization_id= msi.organization_id
1486: AND sysdate <= nvl( org.disable_date, sysdate)
1487: AND org.organization_id= p_ship_from_org_id

Line 1494: org_organization_definitions org

1490: else
1491: SELECT null
1492: INTO l_dummy
1493: FROM mtl_system_items_b msi,
1494: org_organization_definitions org
1495: WHERE msi.inventory_item_id = p_inventory_item_id
1496: AND org.organization_id= msi.organization_id
1497: AND sysdate <= nvl( org.disable_date, sysdate)
1498: AND org.organization_id= p_ship_from_org_id

Line 1506: org_organization_definitions org

1502: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1503: SELECT null
1504: INTO l_dummy
1505: FROM mtl_system_items_b msi,
1506: org_organization_definitions org
1507: WHERE msi.inventory_item_id = p_inventory_item_id
1508: AND org.organization_id= msi.organization_id
1509: AND msi.customer_order_enabled_flag = 'Y'
1510: AND sysdate <= nvl( org.disable_date, sysdate)

Line 2749: org_organization_definitions org

2745:
2746: SELECT purchasing_enabled_flag
2747: INTO l_purchasing_enabled_flag
2748: FROM mtl_system_items msi,
2749: org_organization_definitions org
2750: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2751: AND org.organization_id= msi.organization_id
2752: AND sysdate <= nvl( org.disable_date, sysdate)
2753: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,

Line 2762: org_organization_definitions org

2758: ELSE
2759: SELECT purchasing_enabled_flag
2760: INTO l_purchasing_enabled_flag
2761: FROM mtl_system_items msi,
2762: org_organization_definitions org
2763: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
2764: AND org.organization_id= msi.organization_id
2765: AND sysdate <= nvl( org.disable_date, sysdate)
2766: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,