APPS.CSF_DEBRIEF_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 857: mtl_system_items_b msib

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)
861: and material_billable_flag = billing_type;

Line 1024: from mtl_system_items_b

1020: where name = p_cp_status;
1021:
1022: cursor labor_uom(p_inventory_item_id number) is
1023: select primary_uom_code
1024: from mtl_system_items_b
1025: where inventory_item_id = p_inventory_item_id;
1026:
1027: cursor c_txn_billing_type_id (p_txn_billing_type_id number) is
1028: select ctbt.billing_type,

Line 1042: mtl_system_items_b_kfv msibk

1038: select ctbt.billing_type,
1039: cttv.line_order_category_code
1040: from cs_transaction_types_vl cttv,
1041: cs_txn_billing_types ctbt,
1042: mtl_system_items_b_kfv msibk
1043: where cttv.transaction_type_id = p_transaction_type_id
1044: and cttv.transaction_type_id = ctbt.transaction_type_id
1045: and ctbt.billing_type = msibk.material_billable_flag
1046: and msibk.inventory_item_id = p_inventory_item_id;

Line 1938: from mtl_system_items_b

1934: l_receiving_inventory_org_id number:= null;
1935:
1936: cursor labor_uom(p_inventory_item_id number) is
1937: select primary_uom_code
1938: from mtl_system_items_b
1939: where inventory_item_id = p_inventory_item_id;
1940:
1941: cursor c_uom_code is
1942: select uom_code

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:

Line 3866: from mtl_system_items_b msib

3862: and cdl.transaction_type_id = ctt.transaction_type_id
3863: and ctt.line_order_category_code = 'ORDER'
3864: and (cdl.inventory_item_id in
3865: (select msib.inventory_item_id
3866: from mtl_system_items_b msib
3867: where msib.organization_id = l_organization_id
3868: and msib.inventory_item_id = cdl.inventory_item_id
3869: and msib.material_billable_flag = 'L')
3870: or

Line 3885: from mtl_system_items_b msib

3881: and cdl.transaction_type_id = ctt.transaction_type_id
3882: and ctt.line_order_category_code = 'RETURN'
3883: and (cdl.inventory_item_id in
3884: (select msib.inventory_item_id
3885: from mtl_system_items_b msib
3886: where msib.organization_id = l_organization_id
3887: and msib.inventory_item_id = cdl.inventory_item_id
3888: and msib.material_billable_flag = 'L')
3889: or

Line 3907: from mtl_system_items_b msib

3903: and jtb.task_id = jta.task_id
3904: and jtb.task_id = l_task_id
3905: and (cdl.inventory_item_id in
3906: (select msib.inventory_item_id
3907: from mtl_system_items_b msib
3908: where msib.organization_id = l_organization_id
3909: and msib.inventory_item_id = cdl.inventory_item_id
3910: and msib.material_billable_flag = 'L')
3911: or

Line 3928: from mtl_system_items_b msib

3924: and jtb.task_id = jta.task_id
3925: and jtb.task_id = l_task_id
3926: and (cdl.inventory_item_id in
3927: (select msib.inventory_item_id
3928: from mtl_system_items_b msib
3929: where msib.organization_id = l_organization_id
3930: and msib.inventory_item_id = cdl.inventory_item_id
3931: and msib.material_billable_flag = 'L')
3932: or

Line 3950: from mtl_system_items_b msib

3946: and jtb.task_id = jta.task_id
3947: and jtb.parent_task_id = l_parent_task_id
3948: and (cdl.inventory_item_id in
3949: (select msib.inventory_item_id
3950: from mtl_system_items_b msib
3951: where msib.organization_id = l_organization_id
3952: and msib.inventory_item_id = cdl.inventory_item_id
3953: and msib.material_billable_flag = 'L')
3954: or

Line 3971: from mtl_system_items_b msib

3967: and jtb.task_id = jta.task_id
3968: and jtb.parent_task_id = l_parent_task_id
3969: and (cdl.inventory_item_id in
3970: (select msib.inventory_item_id
3971: from mtl_system_items_b msib
3972: where msib.organization_id = l_organization_id
3973: and msib.inventory_item_id = cdl.inventory_item_id
3974: and msib.material_billable_flag = 'L')
3975: or

Line 4365: from mtl_system_items_b

4361: where read_only_flag = 'U';
4362:
4363: cursor c_serial_control is
4364: select serial_number_control_code
4365: from mtl_system_items_b
4366: where organization_id = p_organization_id
4367: and inventory_item_id = p_inventory_item_id;
4368:
4369: begin