APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CSI_ITEM_INSTANCES

Line 676: select inventory_item_id from csi_item_instances

672: --
673: --BUG 4287842
674:
675: CURSOR get_inv_item_id(p_instance_id number) IS
676: select inventory_item_id from csi_item_instances
677: where instance_id = p_instance_id;
678: --
679: CURSOR acct_from_party(p_party_id number) IS
680: SELECT count(cust_account_id)

Line 2042: from CSI_ITEM_INSTANCES

2038: select serial_number,
2039: lot_number -- Bug 8284773
2040: into l_ib_serial_number,
2041: l_ib_lot_number --Bug 8284773
2042: from CSI_ITEM_INSTANCES
2043: where instance_id = EstDtlTab(i).customer_product_id;
2044: EXCEPTION
2045: -- Serial_number is available only if the instance is serialized
2046: /* WHEN NO_DATA_FOUND THEN