eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_MTL_SYSTEM_ITEMS_ACC_PKG dependencies on CS_BILLING_TYPE_CATEGORIES

Line 81: FROM mtl_system_items_b msi, cs_billing_type_categories cbtc

77: , last_updated_by = 1
78: WHERE resource_id = p_resource_id
79: AND (inventory_item_id, organization_id)
80: IN (SELECT inventory_item_id, organization_id
81: FROM mtl_system_items_b msi, cs_billing_type_categories cbtc
82: WHERE organization_id = p_organization_id
83: and msi.material_billable_flag = cbtc.billing_type (+)
84: AND cbtc.billing_category IN ('E','L'));
85: END IF;

Line 101: FROM mtl_system_items_b msi, cs_billing_type_categories cbtc

97: SELECT jtm_acc_table_s.NEXTVAL, inventory_item_id, organization_id,
98: p_resource_id
99: BULK COLLECT INTO
100: l_tab_access_id, items, organizations, l_tab_resource_id
101: FROM mtl_system_items_b msi, cs_billing_type_categories cbtc
102: WHERE ( inventory_item_id, organization_id ) NOT IN (
103: SELECT inventory_item_id, organization_id
104: FROM jtm_mtl_system_items_acc
105: WHERE resource_id = p_resource_id )

Line 177: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc

173: --Bug 3908277 - Static Query converted into Cursor.
174: CURSOR c_billCat(b_inventory_item_id NUMBER, b_organization_id NUMBER)
175: IS
176: SELECT billing_category
177: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc
178: WHERE msi.material_billable_flag = cbtc.billing_type (+)
179: AND inventory_item_id = p_inventory_item_id
180: AND organization_id = p_organization_id;
181:

Line 184: l_billCat CS_BILLING_TYPE_CATEGORIES.BILLING_CATEGORY%TYPE;

180: AND organization_id = p_organization_id;
181:
182: --Added by UTEKUMAL on 16-Feb-2004 to segregate the Item by Billing Category
183: --Bug 3746689
184: l_billCat CS_BILLING_TYPE_CATEGORIES.BILLING_CATEGORY%TYPE;
185:
186: BEGIN
187: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
188: THEN

Line 264: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc

260: --Bug 3908277 - Static Query converted into Cursor.
261: CURSOR c_billCat(b_inventory_item_id NUMBER, b_organization_id NUMBER)
262: IS
263: SELECT billing_category
264: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc
265: WHERE msi.material_billable_flag = cbtc.billing_type (+)
266: AND inventory_item_id = p_inventory_item_id
267: AND organization_id = p_organization_id;
268:

Line 270: l_billCat CS_BILLING_TYPE_CATEGORIES.BILLING_CATEGORY%TYPE;

266: AND inventory_item_id = p_inventory_item_id
267: AND organization_id = p_organization_id;
268:
269: --Bug 3746689
270: l_billCat CS_BILLING_TYPE_CATEGORIES.BILLING_CATEGORY%TYPE;
271:
272: BEGIN
273: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
274: THEN

Line 651: l_stmt := l_stmt || ' FROM mtl_system_items_b msi, cs_billing_type_categories cbtc';

647: l_stmt := l_stmt || ' SELECT /*+ index (msi MTL_SYSTEM_ITEMS_B_N4)*/ ';
648: l_stmt := l_stmt || ' jtm_acc_table_s.NEXTVAL, SYSDATE, 1, ';
649: l_stmt := l_stmt || ' SYSDATE, 1, 1,'||p_resource_id ||', ';
650: l_stmt := l_stmt || ' inventory_item_id, organization_id ';
651: l_stmt := l_stmt || ' FROM mtl_system_items_b msi, cs_billing_type_categories cbtc';
652: l_stmt := l_stmt || ' WHERE organization_id = :1 ';
653: l_stmt := l_stmt || ' AND msi.material_billable_flag = cbtc.billing_type (+) ';
654: l_stmt := l_stmt || ' AND NVL(cbtc.billing_category, ''M'') = ''M''';
655: l_stmt := l_stmt || ' AND ( INVENTORY_ITEM_ID, ORGANIZATION_ID ) ';

Line 700: FROM mtl_system_items_b msi, cs_billing_type_categories cbtc

696: INSERT INTO JTM_MTL_SYSTEM_ITEMS_ACC(access_id, last_update_date, last_updated_by,
697: creation_date, created_by, counter, resource_id,inventory_item_id, organization_id )
698: SELECT /*+ index (msi MTL_SYSTEM_ITEMS_B_N4)*/ jtm_acc_table_s.NEXTVAL, SYSDATE, 1,
699: SYSDATE, 1, 1, p_resource_id, inventory_item_id, organization_id
700: FROM mtl_system_items_b msi, cs_billing_type_categories cbtc
701: WHERE organization_id = l_profile_org_id
702: AND msi.material_billable_flag = cbtc.billing_type (+)
703: AND cbtc.billing_category IN ('E','L')
704: AND ( inventory_item_id, organization_id )

Line 780: TYPE billCat_Tab IS TABLE OF cs_billing_type_categories.billing_category%TYPE INDEX BY BINARY_INTEGER;

776:
777: l_dummy BOOLEAN;
778:
779: --Bug 3746689
780: TYPE billCat_Tab IS TABLE OF cs_billing_type_categories.billing_category%TYPE INDEX BY BINARY_INTEGER;
781: billCat billCat_Tab;
782:
783: accessId_Exp_Lab_Tab ASG_DOWNLOAD.ACCESS_LIST;
784: accessId_Mat_Tab ASG_DOWNLOAD.ACCESS_LIST;

Line 802: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc

798: b_changed VARCHAR2, b_last_run_date DATE)
799: IS
800: SELECT JTM_ACC_TABLE_S.NEXTVAL, INVENTORY_ITEM_ID, ORGANIZATION_ID, p_resource_id, billing_category
801: BULK COLLECT INTO l_tab_access_id, items, organizations, l_tab_resource_id, billCat
802: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc
803: WHERE ( INVENTORY_ITEM_ID, ORGANIZATION_ID ) NOT IN (
804: SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID
805: FROM JTM_MTL_SYSTEM_ITEMS_ACC
806: WHERE RESOURCE_ID = b_resource_id )

Line 820: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc

816: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER)
817: IS
818: SELECT JTM_ACC_TABLE_S.NEXTVAL, INVENTORY_ITEM_ID, ORGANIZATION_ID, p_resource_id, billing_category
819: BULK COLLECT INTO l_tab_access_id, items, organizations, l_tab_resource_id, billCat
820: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc
821: WHERE ( INVENTORY_ITEM_ID, ORGANIZATION_ID ) NOT IN (
822: SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID
823: FROM JTM_MTL_SYSTEM_ITEMS_ACC
824: WHERE RESOURCE_ID = b_resource_id )

Line 867: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc

863: b_changed VARCHAR2, b_last_run_date DATE, b_category_id NUMBER, b_category_set_id NUMBER)
864: IS
865: SELECT JTM_ACC_TABLE_S.NEXTVAL, INVENTORY_ITEM_ID, ORGANIZATION_ID, p_resource_id, billing_category
866: BULK COLLECT INTO l_tab_access_id, items, organizations, l_tab_resource_id, billCat
867: FROM MTL_SYSTEM_ITEMS_B msi, CS_BILLING_TYPE_CATEGORIES cbtc
868: WHERE ( INVENTORY_ITEM_ID, ORGANIZATION_ID ) NOT IN (
869: SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID
870: FROM JTM_MTL_SYSTEM_ITEMS_ACC
871: WHERE RESOURCE_ID = b_resource_id )

Line 922: l_stmt := l_stmt || ' FROM mtl_system_items_b msi, cs_billing_type_categories cbtc';

918: -- Check material billable flag
919:
920: l_stmt := l_stmt || ' AND (inventory_item_id, organization_id) IN ';
921: l_stmt := l_stmt || ' (SELECT inventory_item_id, organization_id ';
922: l_stmt := l_stmt || ' FROM mtl_system_items_b msi, cs_billing_type_categories cbtc';
923: l_stmt := l_stmt || ' WHERE organization_id = :2 ';
924: l_stmt := l_stmt || ' and msi.material_billable_flag = cbtc.billing_type (+) ';
925: l_stmt := l_stmt || ' AND NVL(cbtc.billing_category, ''M'') = ''M'')';
926:

Line 1202: , CS_BILLING_TYPE_CATEGORIES cbtc

1198: CURSOR c_changed( b_last_date DATE ) IS
1199: SELECT /*+ INDEX (acc JTM_MTL_SYSTEM_ITEMS_ACC_U1) index (msi MTL_SYSTEM_ITEMS_B_U1) */
1200: acc.ACCESS_ID, acc.RESOURCE_ID, cbtc.BILLING_CATEGORY
1201: FROM JTM_MTL_SYSTEM_ITEMS_ACC acc, MTL_SYSTEM_ITEMS_B msi
1202: , CS_BILLING_TYPE_CATEGORIES cbtc
1203: WHERE msi.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
1204: AND msi.ORGANIZATION_ID = acc.ORGANIZATION_ID
1205: AND msi.material_billable_flag = cbtc.billing_type (+)
1206: AND msi.LAST_UPDATE_DATE >= b_last_date;

Line 1213: TYPE billCat_Tab IS TABLE OF cs_billing_type_categories.billing_category%TYPE INDEX BY BINARY_INTEGER;

1209: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
1210: l_dummy BOOLEAN;
1211:
1212: --Bug 3746689
1213: TYPE billCat_Tab IS TABLE OF cs_billing_type_categories.billing_category%TYPE INDEX BY BINARY_INTEGER;
1214: billCat billCat_Tab;
1215: l_billCat cs_billing_type_categories.billing_category%TYPE;
1216:
1217: TYPE sourceType_Tab IS TABLE OF VARCHAR(1) INDEX BY BINARY_INTEGER;

Line 1215: l_billCat cs_billing_type_categories.billing_category%TYPE;

1211:
1212: --Bug 3746689
1213: TYPE billCat_Tab IS TABLE OF cs_billing_type_categories.billing_category%TYPE INDEX BY BINARY_INTEGER;
1214: billCat billCat_Tab;
1215: l_billCat cs_billing_type_categories.billing_category%TYPE;
1216:
1217: TYPE sourceType_Tab IS TABLE OF VARCHAR(1) INDEX BY BINARY_INTEGER;
1218: sourceType sourceType_Tab;
1219: