DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on MTL_ITEM_FLEXFIELDS

Line 512: SELECT 'X' from mtl_item_flexfields where organization_id= p_inv_org

508: p_k_billing_event_rec IN OKE_BILLING_EVENT_PUB.k_billing_event_rec_type) IS
509: L_Value VARCHAR2(1) := 'N';
510:
511: CURSOR C (p_id NUMBER,p_inv_org number) IS
512: SELECT 'X' from mtl_item_flexfields where organization_id= p_inv_org
513: and invoiceable_item_flag='Y' AND inventory_item_id= p_id;
514:
515: CURSOR inv_org IS
516: SELECT Inv_Organization_ID

Line 1209: FROM mtl_item_flexfields

1205:
1206: CURSOR ItemNum ( C_Org_ID NUMBER , C_Item_ID NUMBER ) IS
1207: SELECT item_number
1208: , description
1209: FROM mtl_item_flexfields
1210: WHERE organization_id = C_Org_ID
1211: AND inventory_item_id = C_Item_ID;
1212:
1213: