APPS.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_INVENTORY_TMP_T

Line 665: FROM ozf_inventory_tmp_t;

661: l_msg_count number;
662: -- 6511302 start
663: CURSOR c_inventory_detl IS
664: SELECT *
665: FROM ozf_inventory_tmp_t;
666: l_total_primary_quantity NUMBER;
667: -- 6511302 end
668: BEGIN
669: -- Standard begin of API savepoint

Line 704: INSERT INTO ozf_inventory_tmp_t(

700: -- list => 'OZF_INVENTORY_SUMMARY_MV' ,
701: -- method => '?'
702: -- );
703:
704: INSERT INTO ozf_inventory_tmp_t(
705: creation_date,
706: created_by ,
707: last_update_date,
708: last_updated_by ,

Line 785: INSERT INTO ozf_inventory_tmp_t(

781: , stn.inventory_item_id
782: , stn.primary_uom_code;
783:
784:
785: INSERT INTO ozf_inventory_tmp_t(
786: creation_date,
787: created_by ,
788: last_update_date,
789: last_updated_by ,

Line 861: insert into ozf_inventory_tmp_t(

857: AND hca.party_id = stn.sold_to_party_id
858: );
859:
860: /*
861: insert into ozf_inventory_tmp_t(
862: CREATION_DATE,
863: CREATED_BY ,
864: LAST_UPDATE_DATE,
865: LAST_UPDATED_BY ,

Line 900: FROM ozf_inventory_tmp_t;

896: -- 6511302 (+)
897: IF OZF_DEBUG_LOW_ON THEN
898: SELECT SUM(primary_quantity)
899: INTO l_total_primary_quantity
900: FROM ozf_inventory_tmp_t;
901: OZF_UTILITY_PVT.debug_message(l_full_name||' : total_primary_quantity = '||l_total_primary_quantity);
902:
903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
904: FOR l_inventory_detl IN c_inventory_detl LOOP

Line 1034: update ozf_inventory_tmp_t

1030: ozf_utility_PVT.debug_message('inventory_item_id:' || l_inventory_item_id);
1031: ozf_utility_PVT.debug_message('party_id:' || l_party_id);
1032: END IF;
1033:
1034: update ozf_inventory_tmp_t
1035: set primary_quantity = primary_quantity - l_primary_quantity
1036: where party_id = l_party_id
1037: and inventory_item_id = l_inventory_item_id;
1038:

Line 1120: FROM ozf_inventory_tmp_t

1116: , cv_transaction_date IN DATE
1117: ) IS
1118: SELECT SUM(primary_quantity)
1119: , primary_uom_code
1120: FROM ozf_inventory_tmp_t
1121: --WHERE cust_account_id = cv_cust_account_id
1122: WHERE party_id = cv_party_id
1123: AND inventory_item_id = cv_inventory_item_id
1124: AND transaction_date <= cv_transaction_date

Line 1130: FROM ozf_inventory_tmp_t

1126: -- primary_uom_code is unique per product
1127: /*
1128: CURSOR product_level_csr (p_inventory_item_id IN NUMBER) IS
1129: SELECT primary_uom_code, primary_quantity
1130: FROM ozf_inventory_tmp_t
1131: WHERE inventory_item_id = p_inventory_item_id;
1132: */
1133:
1134: CURSOR csr_primary_uom( cv_party_id IN NUMBER --cv_cust_account_id IN NUMBER

Line 1138: FROM ozf_inventory_tmp_t

1134: CURSOR csr_primary_uom( cv_party_id IN NUMBER --cv_cust_account_id IN NUMBER
1135: , cv_inventory_item_id IN NUMBER
1136: ) IS
1137: SELECT 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 rownum = 1;

Line 1160: FROM ozf_inventory_tmp_t;

1156:
1157: -- 6511302 start
1158: CURSOR c_inventory_detl IS
1159: SELECT *
1160: FROM ozf_inventory_tmp_t;
1161: l_total_primary_quantity NUMBER;
1162: -- 6511302 end
1163: BEGIN
1164: -- Standard begin of API savepoint

Line 1271: INSERT INTO ozf_inventory_tmp_t(

1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);
1268: END IF;
1269: -- 6511302 (-)
1270:
1271: INSERT INTO ozf_inventory_tmp_t(
1272: creation_date,
1273: created_by ,
1274: last_update_date,
1275: last_updated_by ,