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.CS_CHARGE_DETAILS_PVT dependencies on CS_STD

Line 1198: organization_id = cs_std.get_item_valdn_orgzn_id ;

1194: SELECT uom_code
1195: FROM MTL_ITEM_UOMS_VIEW
1196: WHERE uom_code = p_uom_code AND
1197: inventory_item_id = P_INV_ID AND
1198: organization_id = cs_std.get_item_valdn_orgzn_id ;
1199:
1200: lv_exists_flag VARCHAR2(1) := 'N';
1201:
1202: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_uom_valid';

Line 1247: --AND INV_MASTER_ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id;

1243: SELECT instance_id
1244: FROM csi_item_instances
1245: WHERE instance_id = p_instance_id
1246: AND inventory_item_id = p_inv_id;
1247: --AND INV_MASTER_ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id;
1248:
1249: lv_exists_flag VARCHAR2(1) := 'N';
1250:
1251: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_instance_for_inventory';

Line 1300: ITEMS.ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id AND

1296: WHERE cp.instance_id = p_instance_id AND
1297: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1298: -- cp.owner_party_id = p_party_id AND Commented for bug 8552188
1299: ITEMS.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND
1300: ITEMS.ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id AND
1301: exists (select 'x'
1302: from csi_i_parties cip
1303: where cip.party_id = p_party_id
1304: and cip.instance_id = cp.instance_id

Line 1619: organization_id = cs_std.get_item_valdn_orgzn_id ;

1615: SELECT 1
1616: FROM MTL_ITEM_REVISIONS
1617: WHERE inventory_item_id = p_inventory_item_id and
1618: revision = p_item_revision and
1619: organization_id = cs_std.get_item_valdn_orgzn_id ;
1620:
1621: lv_exists_flag VARCHAR2(1) := 'N';
1622:
1623: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_item_revision_valid';

Line 15186: WHERE organization_id = cs_std.get_item_valdn_orgzn_id

15182: revision_qty_control_code,
15183: nvl(comms_nl_trackable_flag, 'N') comms_nl_trackable_flag
15184: -- contract_item_type_code -- Fix for Bug # 3109160
15185: FROM MTL_SYSTEM_ITEMS_KFV
15186: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
15187: AND inventory_item_id = p_inv_id;
15188:
15189:
15190:

Line 15199: --DBMS_OUTPUT.PUT_LINE('cs_std.get_item_valdn_orgzn_id = ' || cs_std.get_item_valdn_orgzn_id);

15195:
15196: -- Initialize API return status to success
15197: x_return_status := FND_API.G_RET_STS_SUCCESS;
15198:
15199: --DBMS_OUTPUT.PUT_LINE('cs_std.get_item_valdn_orgzn_id = ' || cs_std.get_item_valdn_orgzn_id);
15200: --DBMS_OUTPUT.PUT_LINE('p_inv_id = ' || p_inv_id);
15201: --DBMS_OUTPUT.PUT_LINE('p_update_ib_flag = ' || p_update_ib_flag);
15202:
15203:

Line 15300: WHERE organization_id = cs_std.get_item_valdn_orgzn_id

15296: AND bt.billing_type = bc.billing_type
15297: AND bt.transaction_type_id = p_txn_type_id
15298: AND bc.billing_type IN (SELECT material_billable_flag
15299: FROM MTL_SYSTEM_ITEMS_KFV
15300: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
15301: AND inventory_item_id = p_inv_id);
15302:
15303:
15304: lv_exists_flag VARCHAR2(1) := 'N';

Line 15371: AND organization_id = cs_std.get_item_valdn_orgzn_id --

15367: SELECT ctbt.txn_billing_type_id
15368: FROM mtl_system_items_kfv kfv,
15369: cs_txn_billing_types ctbt
15370: WHERE kfv.inventory_item_id = p_inventory_item_id
15371: AND organization_id = cs_std.get_item_valdn_orgzn_id --
15372: AND ctbt.transaction_type_id = p_txn_type_id
15373: AND ctbt.billing_type = kfv.material_billable_flag;
15374:
15375: lv_exists_flag VARCHAR2(1) := 'N';

Line 15434: organization_id = cs_std.get_item_valdn_orgzn_id;

15430: Cursor c_uom(p_inv_id IN NUMBER) IS
15431: SELECT uom_code
15432: FROM MTL_ITEM_UOMS_VIEW
15433: WHERE inventory_item_id = P_INV_ID AND
15434: organization_id = cs_std.get_item_valdn_orgzn_id;
15435:
15436: i NUMBER := 0;
15437:
15438: BEGIN

Line 15453: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);

15449: WHEN OTHERS THEN
15450: x_return_status := FND_API.G_RET_STS_ERROR;
15451: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
15452: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
15453: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
15454: FND_MSG_PUB.Add;
15455: fnd_msg_pub.count_and_get(
15456: p_count => x_msg_count
15457: ,p_data => x_msg_data);

Line 15479: AND msi.organization_id = cs_std.get_item_valdn_orgzn_id;

15475: FROM mtl_system_items_b msi,
15476: MTL_UNITS_OF_MEASURE_TL mum
15477: WHERE msi.PRIMARY_UNIT_OF_MEASURE = mum.unit_of_measure
15478: AND msi.INVENTORY_ITEM_ID = P_INV_ID
15479: AND msi.organization_id = cs_std.get_item_valdn_orgzn_id;
15480:
15481: lv_exists_flag VARCHAR2(1) := 'N';
15482: BEGIN
15483: -- Initialize API return status to success

Line 15496: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);

15492: --RAISE FND_API.G_EXC_ERROR;
15493: --null;
15494: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
15495: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
15496: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
15497: FND_MSG_PUB.Add;
15498: RAISE FND_API.G_EXC_ERROR;
15499: END IF;
15500:

Line 15513: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);

15509: WHEN OTHERS THEN
15510: x_return_status := FND_API.G_RET_STS_ERROR;
15511: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
15512: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
15513: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
15514: FND_MSG_PUB.Add;
15515: fnd_msg_pub.count_and_get(
15516: p_count => x_msg_count
15517: ,p_data => x_msg_data);