[Home] [Help]
50: END IF;
51:
52: -- Have a different cursor instead of using the cursor for openOnlineItemChangeCursor
53: -- because since the category assignment has deleted, in this case we need to do an
54: -- outer join with mtl_item_categories and check if the po_category_id is null
55: -- and the row is present in icx_cat_items_ctx_hdrs_tlpm then we need to remove these
56: -- items from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp
57:
58: l_err_loc := 300;
98: mparams.master_organization_id
99: FROM mtl_system_items_b mi,
100: mtl_parameters mparams,
101: mtl_system_items_tl mitl,
102: mtl_item_categories mic,
103: mtl_units_of_measure muom,
104: financials_system_params_all fsp,
105: icx_por_category_data_sources catMap
106: WHERE mi.inventory_item_id = p_inventory_item_id
229: mparams.master_organization_id
230: FROM mtl_system_items_b mi,
231: mtl_parameters mparams,
232: mtl_system_items_tl mitl,
233: mtl_item_categories mic,
234: mtl_units_of_measure muom,
235: financials_system_params_all fsp,
236: icx_por_category_data_sources catMap
237: WHERE mi.inventory_item_id = p_inventory_item_id
364: FROM mtl_system_items_b mi,
365: mtl_parameters mparams,
366: mtl_item_bulkload_recs mbulk,
367: mtl_system_items_tl mitl,
368: mtl_item_categories mic,
369: mtl_units_of_measure muom,
370: financials_system_params_all fsp,
371: icx_por_category_data_sources catMap
372: WHERE mbulk.request_id = p_request_id
463: FROM mtl_system_items_b mi,
464: mtl_parameters mparams,
465: mtl_item_bulkload_recs mbulk,
466: mtl_system_items_tl mitl,
467: mtl_item_categories mic,
468: mtl_units_of_measure muom,
469: mtl_category_sets msets,
470: financials_system_params_all fsp,
471: icx_por_category_data_sources catMap
546: FROM mtl_system_items_b mi,
547: mtl_parameters mparams,
548: mtl_item_bulkload_recs mbulk,
549: mtl_system_items_tl mitl,
550: mtl_item_categories mic,
551: mtl_units_of_measure muom,
552: mtl_category_sets msets,
553: financials_system_params_all fsp,
554: icx_por_category_data_sources catMap
673: mparams.master_organization_id
674: FROM mtl_system_items_b mi,
675: mtl_parameters mparams,
676: mtl_system_items_tl mitl,
677: mtl_item_categories mic,
678: mtl_units_of_measure muom,
679: financials_system_params_all fsp,
680: icx_por_category_data_sources catMap
681: WHERE mi.inventory_item_id = mitl.inventory_item_id
794: mparams.master_organization_id
795: FROM mtl_system_items_b mi,
796: mtl_parameters mparams,
797: mtl_system_items_tl mitl,
798: mtl_item_categories mic,
799: mtl_units_of_measure muom,
800: financials_system_params_all fsp,
801: icx_por_category_data_sources catMap
802: WHERE mi.inventory_item_id = mitl.inventory_item_id
871: mparams.master_organization_id
872: FROM mtl_system_items_b mi,
873: mtl_parameters mparams,
874: mtl_system_items_tl mitl,
875: mtl_item_categories mic,
876: mtl_units_of_measure muom,
877: financials_system_params_all fsp,
878: icx_por_category_data_sources catMap
879: WHERE mi.inventory_item_id = mitl.inventory_item_id