APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_INVENTORY_TMP_T

Line 683: FROM ozf_inventory_tmp_t;

679: l_msg_count number;
680: -- 6511302 start
681: CURSOR c_inventory_detl IS
682: SELECT *
683: FROM ozf_inventory_tmp_t;
684: l_total_primary_quantity NUMBER;
685: -- 6511302 end
686: BEGIN
687: -- Standard begin of API savepoint

Line 722: INSERT INTO ozf_inventory_tmp_t(

718: -- list => 'OZF_INVENTORY_SUMMARY_MV' ,
719: -- method => '?'
720: -- );
721:
722: INSERT INTO ozf_inventory_tmp_t(
723: creation_date,
724: created_by ,
725: last_update_date,
726: last_updated_by ,

Line 803: INSERT INTO ozf_inventory_tmp_t(

799: , stn.inventory_item_id
800: , stn.primary_uom_code;
801:
802:
803: INSERT INTO ozf_inventory_tmp_t(
804: creation_date,
805: created_by ,
806: last_update_date,
807: last_updated_by ,

Line 879: insert into ozf_inventory_tmp_t(

875: -- AND hca.party_id = stn.sold_to_party_id -- fix for bug 14761031
876: );
877:
878: /*
879: insert into ozf_inventory_tmp_t(
880: CREATION_DATE,
881: CREATED_BY ,
882: LAST_UPDATE_DATE,
883: LAST_UPDATED_BY ,

Line 918: FROM ozf_inventory_tmp_t;

914: -- 6511302 (+)
915: IF OZF_DEBUG_LOW_ON THEN
916: SELECT SUM(primary_quantity)
917: INTO l_total_primary_quantity
918: FROM ozf_inventory_tmp_t;
919: OZF_UTILITY_PVT.debug_message(l_full_name||' : total_primary_quantity = '||l_total_primary_quantity);
920:
921: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
922: FOR l_inventory_detl IN c_inventory_detl LOOP

Line 1052: update ozf_inventory_tmp_t

1048: ozf_utility_PVT.debug_message('inventory_item_id:' || l_inventory_item_id);
1049: ozf_utility_PVT.debug_message('party_id:' || l_party_id);
1050: END IF;
1051:
1052: update ozf_inventory_tmp_t
1053: set primary_quantity = primary_quantity - l_primary_quantity
1054: where party_id = l_party_id
1055: and inventory_item_id = l_inventory_item_id;
1056:

Line 1138: FROM ozf_inventory_tmp_t

1134: , cv_transaction_date IN DATE
1135: ) IS
1136: SELECT SUM(primary_quantity)
1137: , primary_uom_code
1138: FROM ozf_inventory_tmp_t
1139: --WHERE cust_account_id = cv_cust_account_id
1140: WHERE party_id = cv_party_id
1141: AND inventory_item_id = cv_inventory_item_id
1142: AND transaction_date <= cv_transaction_date

Line 1148: FROM ozf_inventory_tmp_t

1144: -- primary_uom_code is unique per product
1145: /*
1146: CURSOR product_level_csr (p_inventory_item_id IN NUMBER) IS
1147: SELECT primary_uom_code, primary_quantity
1148: FROM ozf_inventory_tmp_t
1149: WHERE inventory_item_id = p_inventory_item_id;
1150: */
1151:
1152: CURSOR csr_primary_uom( cv_party_id IN NUMBER --cv_cust_account_id IN NUMBER

Line 1156: FROM ozf_inventory_tmp_t

1152: CURSOR csr_primary_uom( cv_party_id IN NUMBER --cv_cust_account_id IN NUMBER
1153: , cv_inventory_item_id IN NUMBER
1154: ) IS
1155: SELECT primary_uom_code
1156: FROM ozf_inventory_tmp_t
1157: --WHERE cust_account_id = cv_cust_account_id
1158: WHERE party_id = cv_party_id
1159: AND inventory_item_id = cv_inventory_item_id
1160: AND rownum = 1;

Line 1178: FROM ozf_inventory_tmp_t;

1174:
1175: -- 6511302 start
1176: CURSOR c_inventory_detl IS
1177: SELECT *
1178: FROM ozf_inventory_tmp_t;
1179: l_total_primary_quantity NUMBER;
1180: -- 6511302 end
1181: BEGIN
1182: -- Standard begin of API savepoint

Line 1295: INSERT INTO ozf_inventory_tmp_t(

1291: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);
1292: END IF;
1293: -- 6511302 (-)
1294:
1295: INSERT INTO ozf_inventory_tmp_t(
1296: creation_date,
1297: created_by ,
1298: last_update_date,
1299: last_updated_by ,