APPS.CSF_DEBRIEF_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 844: mtl_system_items_b msib

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

Line 1022: from mtl_system_items_b

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

Line 1040: mtl_system_items_b_kfv msibk

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

Line 1885: from mtl_system_items_b

1881: l_receiving_inventory_org_id number:= null;
1882:
1883: cursor labor_uom(p_inventory_item_id number) is
1884: select primary_uom_code
1885: from mtl_system_items_b
1886: where inventory_item_id = p_inventory_item_id;
1887:
1888: cursor c_uom_code is
1889: select uom_code

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:

Line 3422: from mtl_system_items_b msib

3418: and cdl.transaction_type_id = ctt.transaction_type_id
3419: and ctt.line_order_category_code = 'ORDER'
3420: and (cdl.inventory_item_id in
3421: (select msib.inventory_item_id
3422: from mtl_system_items_b msib
3423: where msib.organization_id = l_organization_id
3424: and msib.inventory_item_id = cdl.inventory_item_id
3425: and msib.material_billable_flag = 'L')
3426: or

Line 3441: from mtl_system_items_b msib

3437: and cdl.transaction_type_id = ctt.transaction_type_id
3438: and ctt.line_order_category_code = 'RETURN'
3439: and (cdl.inventory_item_id in
3440: (select msib.inventory_item_id
3441: from mtl_system_items_b msib
3442: where msib.organization_id = l_organization_id
3443: and msib.inventory_item_id = cdl.inventory_item_id
3444: and msib.material_billable_flag = 'L')
3445: or

Line 3463: from mtl_system_items_b msib

3459: and jtb.task_id = jta.task_id
3460: and jtb.task_id = l_task_id
3461: and (cdl.inventory_item_id in
3462: (select msib.inventory_item_id
3463: from mtl_system_items_b msib
3464: where msib.organization_id = l_organization_id
3465: and msib.inventory_item_id = cdl.inventory_item_id
3466: and msib.material_billable_flag = 'L')
3467: or

Line 3484: from mtl_system_items_b msib

3480: and jtb.task_id = jta.task_id
3481: and jtb.task_id = l_task_id
3482: and (cdl.inventory_item_id in
3483: (select msib.inventory_item_id
3484: from mtl_system_items_b msib
3485: where msib.organization_id = l_organization_id
3486: and msib.inventory_item_id = cdl.inventory_item_id
3487: and msib.material_billable_flag = 'L')
3488: or

Line 3506: from mtl_system_items_b msib

3502: and jtb.task_id = jta.task_id
3503: and jtb.parent_task_id = l_parent_task_id
3504: and (cdl.inventory_item_id in
3505: (select msib.inventory_item_id
3506: from mtl_system_items_b msib
3507: where msib.organization_id = l_organization_id
3508: and msib.inventory_item_id = cdl.inventory_item_id
3509: and msib.material_billable_flag = 'L')
3510: or

Line 3527: from mtl_system_items_b msib

3523: and jtb.task_id = jta.task_id
3524: and jtb.parent_task_id = l_parent_task_id
3525: and (cdl.inventory_item_id in
3526: (select msib.inventory_item_id
3527: from mtl_system_items_b msib
3528: where msib.organization_id = l_organization_id
3529: and msib.inventory_item_id = cdl.inventory_item_id
3530: and msib.material_billable_flag = 'L')
3531: or