APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKE_SYSTEM_ITEMS_V

Line 764: Select Effectivity_Control From oke_system_items_v

760: l_Choice NUMBER;
761: raise_date_exception BOOLEAN;
762:
763: Cursor Unit_c(p_item_id Number, p_org_id Number) Is
764: Select Effectivity_Control From oke_system_items_v
765: Where Id1 = p_item_id
766: And Id2 = p_org_id;
767:
768: cursor l_control_csr is

Line 774: SELECT 'X' FROM OKE_SYSTEM_ITEMS_V

770: from pjm_org_parameters
771: where organization_id = l_id;
772:
773: CURSOR ship_c IS
774: SELECT 'X' FROM OKE_SYSTEM_ITEMS_V
775: WHERE ID1 = l_id
776: AND ID2 = l_inventory_org_id
777: AND SHIPPABLE_ITEM_FLAG = 'Y';
778:

Line 780: SELECT 'X' FROM OKE_SYSTEM_ITEMS_V

776: AND ID2 = l_inventory_org_id
777: AND SHIPPABLE_ITEM_FLAG = 'Y';
778:
779: CURSOR req_c IS
780: SELECT 'X' FROM OKE_SYSTEM_ITEMS_V
781: WHERE ID1 = l_id
782: AND ID2 = l_inventory_org_id
783: AND PURCHASING_ENABLED_FLAG = 'Y';
784:

Line 786: select 'X' from oke_system_items_v

782: AND ID2 = l_inventory_org_id
783: AND PURCHASING_ENABLED_FLAG = 'Y';
784:
785: cursor bill_c is
786: select 'X' from oke_system_items_v
787: where id1 = l_id
788: and id2 = l_inventory_org_id
789: and invoiceable_item_flag = 'Y';
790:

Line 793: FROM oke_system_items_v

789: and invoiceable_item_flag = 'Y';
790:
791: CURSOR Item_C IS
792: SELECT 'X'
793: FROM oke_system_items_v
794: WHERE ID1 = L_ID
795: AND ID2 = L_Inventory_Org_ID;
796:
797: begin