R12 Ürün Ağacı Patlatma ( R12 BOM EXPLOSION)

DECLARE l_model_item VARCHAR2 (100); l_organization_code VARCHAR2 (100); l_model_item_id NUMBER; l_organization_id NUMBER; l_cnt NUMBER DEFAULT 0; l_err_msg VARCHAR2 (240); l_err_code NUMBER DEFAULT 0; l_verify_flag NUMBER DEFAULT 0; l_online_flag NUMBER DEFAULT 2; l_item_id NUMBER DEFAULT 0; l_org_id NUMBER DEFAULT 0; l_alternate VARCHAR2 (240) DEFAULT NULL; l_list_id NUMBER DEFAULT 0; l_order_by NUMBER DEFAULT 1; l_grp_id NUMBER DEFAULT 0; […]