APPS.CTO_AUTO_PROCURE_PK dependencies on MTL_PARAMETERS

Line 357: from bom_calendar_dates cal, mtl_parameters mp

353: -- rkaza. Need to consider the manufacturing calendar while
354: -- determining need by date
355:
356: select CAL.CALENDAR_DATE into x_need_by_date
357: from bom_calendar_dates cal, mtl_parameters mp
358: where mp.organization_id = p_org_id
359: and cal.calendar_code = mp.calendar_code
360: and cal.exception_set_id = mp.calendar_exception_set_id
361: and cal.seq_num = (select cal2.prior_seq_num - nvl(l_offset_days, 0)

Line 1297: -- Select material account from mtl_parameters instead of receiving account

1293: --and bugfix 3129117
1294: l_pegging_flag VARCHAR2(1) := 'Y'; --bug 3042904
1295:
1296: -- rkaza. 07/16/2004. bug 3771585.
1297: -- Select material account from mtl_parameters instead of receiving account
1298: -- from rcv_paramters
1299: CURSOR charge_account_cur (i_org_id NUMBER ) IS
1300: SELECT material_account
1301: FROM mtl_parameters

Line 1301: FROM mtl_parameters

1297: -- Select material account from mtl_parameters instead of receiving account
1298: -- from rcv_paramters
1299: CURSOR charge_account_cur (i_org_id NUMBER ) IS
1300: SELECT material_account
1301: FROM mtl_parameters
1302: WHERE organization_id = i_org_id;
1303:
1304: CURSOR emp_id (i_created_by NUMBER) IS
1305: SELECT employee_id

Line 1677: -- Select material account from mtl_parameters instead of receiving

1673:
1674: l_stmt_num := 150;
1675: FOR ch_act IN charge_account_cur (p_destination_org_id) LOOP
1676: -- rkaza. 07/16/2004. bug 3771585.
1677: -- Select material account from mtl_parameters instead of receiving
1678: -- account from rcv_paramters
1679: -- p_receiving_account_id := ch_act.receiving_account_id;
1680: p_receiving_account_id := ch_act.material_account;
1681: IF PG_DEBUG <> 0 THEN

Line 4102: mtl_parameters mp

4098: /* Bug 5520934 begin: We need to honour bom calendar in offset days calculation */
4099: -- or (oel.schedule_ship_date <= trunc( sysdate + p_offset_days)))
4100: or (sysdate >= (select cal.calendar_date
4101: from bom_calendar_dates cal,
4102: mtl_parameters mp
4103: where mp.organization_id = oel.ship_from_org_id
4104: and cal.calendar_code = mp.calendar_code
4105: and cal.exception_set_id = mp.calendar_exception_set_id
4106: and cal.seq_num = (select cal2.prior_seq_num - nvl(p_offset_days, 0)

Line 4881: mtl_parameters mp

4877: --sql_stmt := sql_stmt ||' and oel.schedule_ship_date <= trunc( sysdate + :p_offset_days) ';
4878: /* Bug 5520934 : We need to honour bom_calendar in offset days calculation */
4879: sql_stmt := sql_stmt ||' and sysdate >= (select cal.calendar_date
4880: from bom_calendar_dates cal,
4881: mtl_parameters mp
4882: where mp.organization_id = oel.ship_from_org_id
4883: and cal.calendar_code = mp.calendar_code
4884: and cal.exception_set_id = mp.calendar_exception_set_id
4885: and cal.seq_num = (select cal2.prior_seq_num - nvl(:p_offset_days, 0)