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 1161: organization_id = cs_std.get_item_valdn_orgzn_id ;

1157: SELECT uom_code
1158: FROM MTL_ITEM_UOMS_VIEW
1159: WHERE uom_code = p_uom_code AND
1160: inventory_item_id = P_INV_ID AND
1161: organization_id = cs_std.get_item_valdn_orgzn_id ;
1162:
1163: lv_exists_flag VARCHAR2(1) := 'N';
1164:
1165: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_uom_valid';

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

1206: SELECT instance_id
1207: FROM csi_item_instances
1208: WHERE instance_id = p_instance_id
1209: AND inventory_item_id = p_inv_id;
1210: --AND INV_MASTER_ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id;
1211:
1212: lv_exists_flag VARCHAR2(1) := 'N';
1213:
1214: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_instance_for_inventory';

Line 1261: ITEMS.ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id AND

1257: WHERE cp.instance_id = p_instance_id AND
1258: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1259: cp.owner_party_id = p_party_id AND
1260: ITEMS.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND
1261: ITEMS.ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id AND
1262: exists (select 'x'
1263: from csi_i_parties cip
1264: where cip.party_id = p_party_id
1265: and cip.instance_id = cp.instance_id

Line 1519: organization_id = cs_std.get_item_valdn_orgzn_id ;

1515: SELECT 1
1516: FROM MTL_ITEM_REVISIONS
1517: WHERE inventory_item_id = p_inventory_item_id and
1518: revision = p_item_revision and
1519: organization_id = cs_std.get_item_valdn_orgzn_id ;
1520:
1521: lv_exists_flag VARCHAR2(1) := 'N';
1522:
1523: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_item_revision_valid';

Line 13649: WHERE organization_id = cs_std.get_item_valdn_orgzn_id

13645: revision_qty_control_code,
13646: nvl(comms_nl_trackable_flag, 'N') comms_nl_trackable_flag
13647: -- contract_item_type_code -- Fix for Bug # 3109160
13648: FROM MTL_SYSTEM_ITEMS_KFV
13649: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
13650: AND inventory_item_id = p_inv_id;
13651:
13652:
13653:

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

13658:
13659: -- Initialize API return status to success
13660: x_return_status := FND_API.G_RET_STS_SUCCESS;
13661:
13662: --DBMS_OUTPUT.PUT_LINE('cs_std.get_item_valdn_orgzn_id = ' || cs_std.get_item_valdn_orgzn_id);
13663: --DBMS_OUTPUT.PUT_LINE('p_inv_id = ' || p_inv_id);
13664: --DBMS_OUTPUT.PUT_LINE('p_update_ib_flag = ' || p_update_ib_flag);
13665:
13666:

Line 13763: WHERE organization_id = cs_std.get_item_valdn_orgzn_id

13759: AND bt.billing_type = bc.billing_type
13760: AND bt.transaction_type_id = p_txn_type_id
13761: AND bc.billing_type IN (SELECT material_billable_flag
13762: FROM MTL_SYSTEM_ITEMS_KFV
13763: WHERE organization_id = cs_std.get_item_valdn_orgzn_id
13764: AND inventory_item_id = p_inv_id);
13765:
13766:
13767: lv_exists_flag VARCHAR2(1) := 'N';

Line 13834: AND organization_id = cs_std.get_item_valdn_orgzn_id --

13830: SELECT ctbt.txn_billing_type_id
13831: FROM mtl_system_items_kfv kfv,
13832: cs_txn_billing_types ctbt
13833: WHERE kfv.inventory_item_id = p_inventory_item_id
13834: AND organization_id = cs_std.get_item_valdn_orgzn_id --
13835: AND ctbt.transaction_type_id = p_txn_type_id
13836: AND ctbt.billing_type = kfv.material_billable_flag;
13837:
13838: lv_exists_flag VARCHAR2(1) := 'N';

Line 13897: organization_id = cs_std.get_item_valdn_orgzn_id;

13893: Cursor c_uom(p_inv_id IN NUMBER) IS
13894: SELECT uom_code
13895: FROM MTL_ITEM_UOMS_VIEW
13896: WHERE inventory_item_id = P_INV_ID AND
13897: organization_id = cs_std.get_item_valdn_orgzn_id;
13898:
13899: i NUMBER := 0;
13900:
13901: BEGIN

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

13912: WHEN OTHERS THEN
13913: x_return_status := FND_API.G_RET_STS_ERROR;
13914: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
13915: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
13916: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
13917: FND_MSG_PUB.Add;
13918: fnd_msg_pub.count_and_get(
13919: p_count => x_msg_count
13920: ,p_data => x_msg_data);

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

13938: FROM mtl_system_items_b msi,
13939: MTL_UNITS_OF_MEASURE_TL mum
13940: WHERE msi.PRIMARY_UNIT_OF_MEASURE = mum.unit_of_measure
13941: AND msi.INVENTORY_ITEM_ID = P_INV_ID
13942: AND msi.organization_id = cs_std.get_item_valdn_orgzn_id;
13943:
13944: lv_exists_flag VARCHAR2(1) := 'N';
13945: BEGIN
13946: -- Initialize API return status to success

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

13955: --RAISE FND_API.G_EXC_ERROR;
13956: --null;
13957: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
13958: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
13959: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
13960: FND_MSG_PUB.Add;
13961: RAISE FND_API.G_EXC_ERROR;
13962: END IF;
13963:

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

13972: WHEN OTHERS THEN
13973: x_return_status := FND_API.G_RET_STS_ERROR;
13974: FND_MESSAGE.Set_Name('CS', 'CS_CHG_GET_UOM_FAILED');
13975: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', p_inv_id);
13976: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID', cs_std.get_item_valdn_orgzn_id);
13977: FND_MSG_PUB.Add;
13978: fnd_msg_pub.count_and_get(
13979: p_count => x_msg_count
13980: ,p_data => x_msg_data);