DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 856: from cs_billing_type_categories cbtc,

852: l_valid_org number := fnd_profile.value('CS_INV_VALIDATION_ORG');
853:
854: cursor c_debrief_type is
855: select billing_category
856: from cs_billing_type_categories cbtc,
857: mtl_system_items_b msib
858: where inventory_item_id = p_debrief_line_rec.inventory_item_id
859: and organization_id = l_valid_org -- changed for bug 4259770
860: -- nvl(p_debrief_line_rec.issuing_inventory_org_id, p_debrief_line_rec.receiving_inventory_org_id)

Line 2551: from mtl_system_items_b msib,cs_billing_type_categories cbtc

2547:
2548: l_inventory_item_id number;
2549: cursor c_inventory_item is
2550: select msib.inventory_item_id
2551: from mtl_system_items_b msib,cs_billing_type_categories cbtc
2552: where msib.organization_id = nvl(p_organization_id,fnd_profile.value('CS_INV_VALIDATION_ORG'))
2553: and msib.inventory_item_id = p_inventory_item_id
2554: and msib.material_billable_flag = cbtc.billing_type;
2555: