DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on MTL_PARAMETERS

Line 6915: mtl_parameters mp,

6911: round(bst.from_time / 60) start_time,
6912: nvl(brs.CAPACITY_UNITS, 0) cap_units,
6913: brs.shift_num shift_num
6914: from bom_resource_shifts brs,
6915: mtl_parameters mp,
6916: bom_shift_dates bsd,
6917: bom_shift_times bst
6918: where brs.department_id = p_dept_id
6919: and brs.resource_id = p_resource_id

Line 9869: FROM mtl_parameters

9865: --get the values related to cartonization from org parameters
9866: BEGIN
9867: SELECT NVL(cartonization_flag, -1), NVL(cartonize_sales_orders, 'Y')
9868: INTO v_cart_value, l_cartonize_sales_orders
9869: FROM mtl_parameters
9870: WHERE organization_id = p_organization_id;
9871: EXCEPTION
9872: WHEN OTHERS THEN
9873: v_cart_value := NULL;

Line 11822: from mtl_parameters

11818: -- 13361256
11819: begin
11820: select decode(MO_PICK_CONFIRM_REQUIRED,1,'N',2,'Y')
11821: into new_wave_type.auto_pick_confirm_flag
11822: from mtl_parameters
11823: where organization_id = p_ORGANIZATION_ID;
11824: print_debug('new_wave_type.auto_pick_confirm_flag '||new_wave_type.auto_pick_confirm_flag, l_debug);
11825: exception
11826: when others then

Line 18160: MTL_PARAMETERS MP,

18156: WMS_WP_WAVE_LINES WWL,
18157: WSH_NEW_DELIVERIES WND,
18158: MTL_SYSTEM_ITEMS_KFV MSIV,
18159: WSH_CARRIERS WC,
18160: MTL_PARAMETERS MP,
18161: WMS_LICENSE_PLATE_NUMBERS WLPN,
18162: WSH_DELIVERY_ASSIGNMENTS WDA,
18163: WSH_TRIP_STOPS WTS,
18164: WSH_DELIVERY_LEGS WLG,

Line 18278: FROM mtl_parameters

18274: mmtt.transaction_source_id,
18275: mmtt.trx_source_line_id,
18276: mmtt.organization_id,
18277: (SELECT organization_code
18278: FROM mtl_parameters
18279: WHERE organization_id = mmtt.organization_id) organization_code,
18280: mmtt.transfer_organization to_organization_id,
18281: (SELECT organization_code
18282: FROM mtl_parameters

Line 18282: FROM mtl_parameters

18278: FROM mtl_parameters
18279: WHERE organization_id = mmtt.organization_id) organization_code,
18280: mmtt.transfer_organization to_organization_id,
18281: (SELECT organization_code
18282: FROM mtl_parameters
18283: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18284: mmtt.transfer_subinventory to_subinventory,
18285: mmtt.transfer_to_location to_locator_id,
18286: (SELECT mil.concatenated_segments --bug12642410

Line 18427: FROM mtl_parameters

18423: mmtt.transaction_source_id,
18424: mmtt.trx_source_line_id,
18425: mmtt.organization_id,
18426: (SELECT organization_code
18427: FROM mtl_parameters
18428: WHERE organization_id = mmtt.organization_id) organization_code,
18429: mmtt.transfer_organization to_organization_id,
18430: (SELECT organization_code
18431: FROM mtl_parameters

Line 18431: FROM mtl_parameters

18427: FROM mtl_parameters
18428: WHERE organization_id = mmtt.organization_id) organization_code,
18429: mmtt.transfer_organization to_organization_id,
18430: (SELECT organization_code
18431: FROM mtl_parameters
18432: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18433: mmtt.transfer_subinventory to_subinventory,
18434: mmtt.transfer_to_location to_locator_id,
18435: (SELECT mil.concatenated_segments --bug12642410

Line 18559: FROM mtl_parameters

18555: mmtt.transaction_source_id,
18556: mmtt.trx_source_line_id,
18557: mmtt.organization_id,
18558: (SELECT organization_code
18559: FROM mtl_parameters
18560: WHERE organization_id = mmtt.organization_id) organization_code,
18561: mmtt.transfer_organization to_organization_id,
18562: (SELECT organization_code
18563: FROM mtl_parameters

Line 18563: FROM mtl_parameters

18559: FROM mtl_parameters
18560: WHERE organization_id = mmtt.organization_id) organization_code,
18561: mmtt.transfer_organization to_organization_id,
18562: (SELECT organization_code
18563: FROM mtl_parameters
18564: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18565: mmtt.transfer_subinventory to_subinventory,
18566: mmtt.transfer_to_location to_locator_id,
18567: (select mil.concatenated_segments --bug12642410

Line 18712: FROM mtl_parameters

18708: mmt.transaction_source_id,
18709: mmt.trx_source_line_id,
18710: mmt.organization_id,
18711: (SELECT organization_code
18712: FROM mtl_parameters
18713: WHERE organization_id = mmt.organization_id) organization_code,
18714: mmt.transfer_organization_id to_organization_id,
18715: (SELECT organization_code
18716: FROM mtl_parameters

Line 18716: FROM mtl_parameters

18712: FROM mtl_parameters
18713: WHERE organization_id = mmt.organization_id) organization_code,
18714: mmt.transfer_organization_id to_organization_id,
18715: (SELECT organization_code
18716: FROM mtl_parameters
18717: WHERE organization_id = mmt.transfer_organization_id) to_organization_code,
18718: mmt.transfer_subinventory to_subinventory,
18719: mmt.transfer_locator_id to_locator_id,
18720: (SELECT mil.concatenated_segments --bug12642410

Line 18895: FROM mtl_parameters

18891: mmtt.transaction_source_id,
18892: mmtt.trx_source_line_id,
18893: mmtt.organization_id,
18894: (SELECT organization_code
18895: FROM mtl_parameters
18896: WHERE organization_id = mmtt.organization_id) organization_code,
18897: mmtt.transfer_organization to_organization_id,
18898: (SELECT organization_code
18899: FROM mtl_parameters

Line 18899: FROM mtl_parameters

18895: FROM mtl_parameters
18896: WHERE organization_id = mmtt.organization_id) organization_code,
18897: mmtt.transfer_organization to_organization_id,
18898: (SELECT organization_code
18899: FROM mtl_parameters
18900: WHERE organization_id = mmtt.transfer_organization) to_organization_code,
18901: mmtt.transfer_subinventory to_subinventory,
18902: mmtt.transfer_to_location to_locator_id,
18903: (SELECT mil.concatenated_segments --bug12642410

Line 19045: FROM mtl_parameters

19041: to_number(null) transaction_source_id,
19042: to_number(null) trx_source_line_id,
19043: wdth.organization_id,
19044: (SELECT organization_code
19045: FROM mtl_parameters
19046: WHERE organization_id = wdth.organization_id) organization_code,
19047: wdth.transfer_organization_id to_organization_id,
19048: (SELECT organization_code
19049: FROM mtl_parameters

Line 19049: FROM mtl_parameters

19045: FROM mtl_parameters
19046: WHERE organization_id = wdth.organization_id) organization_code,
19047: wdth.transfer_organization_id to_organization_id,
19048: (SELECT organization_code
19049: FROM mtl_parameters
19050: WHERE organization_id = wdth.transfer_organization_id) to_organization_code,
19051: wdth.dest_subinventory_code to_subinventory,
19052: wdth.dest_locator_id to_locator_id,
19053: (SELECT mil.concatenated_segments --bug12642410