DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 843: from cs_billing_type_categories cbtc,

839: l_valid_org number := fnd_profile.value('CS_INV_VALIDATION_ORG');
840:
841: cursor c_debrief_type is
842: select billing_category
843: from cs_billing_type_categories cbtc,
844: mtl_system_items_b msib
845: where inventory_item_id = p_debrief_line_rec.inventory_item_id
846: and organization_id = l_valid_org -- changed for bug 4259770
847: -- nvl(p_debrief_line_rec.issuing_inventory_org_id, p_debrief_line_rec.receiving_inventory_org_id)

Line 2483: from mtl_system_items_b msib,cs_billing_type_categories cbtc

2479:
2480: l_inventory_item_id number;
2481: cursor c_inventory_item is
2482: select msib.inventory_item_id
2483: from mtl_system_items_b msib,cs_billing_type_categories cbtc
2484: where msib.organization_id = nvl(p_organization_id,fnd_profile.value('CS_INV_VALIDATION_ORG'))
2485: and msib.inventory_item_id = p_inventory_item_id
2486: and msib.material_billable_flag = cbtc.billing_type;
2487: