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 1609: -- Select material account from mtl_parameters instead of receiving account

1605: --and bugfix 3129117
1606: l_pegging_flag VARCHAR2(1) := 'Y'; --bug 3042904
1607:
1608: -- rkaza. 07/16/2004. bug 3771585.
1609: -- Select material account from mtl_parameters instead of receiving account
1610: -- from rcv_paramters
1611: CURSOR charge_account_cur (i_org_id NUMBER ) IS
1612: SELECT material_account
1613: FROM mtl_parameters

Line 1613: FROM mtl_parameters

1609: -- Select material account from mtl_parameters instead of receiving account
1610: -- from rcv_paramters
1611: CURSOR charge_account_cur (i_org_id NUMBER ) IS
1612: SELECT material_account
1613: FROM mtl_parameters
1614: WHERE organization_id = i_org_id;
1615:
1616: CURSOR emp_id (i_created_by NUMBER) IS
1617: SELECT employee_id

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

1996:
1997: l_stmt_num := 150;
1998: FOR ch_act IN charge_account_cur (p_destination_org_id) LOOP
1999: -- rkaza. 07/16/2004. bug 3771585.
2000: -- Select material account from mtl_parameters instead of receiving
2001: -- account from rcv_paramters
2002: -- p_receiving_account_id := ch_act.receiving_account_id;
2003: p_receiving_account_id := ch_act.material_account;
2004: IF PG_DEBUG <> 0 THEN

Line 4512: mtl_parameters mp

4508: /* Bug 5520934 begin: We need to honour bom calendar in offset days calculation */
4509: -- or (oel.schedule_ship_date <= trunc( sysdate + p_offset_days)))
4510: or (sysdate >= (select cal.calendar_date
4511: from bom_calendar_dates cal,
4512: mtl_parameters mp
4513: where mp.organization_id = oel.ship_from_org_id
4514: and cal.calendar_code = mp.calendar_code
4515: and cal.exception_set_id = mp.calendar_exception_set_id
4516: and cal.seq_num = (select cal2.prior_seq_num - nvl(p_offset_days, 0)

Line 5302: mtl_parameters mp

5298: --sql_stmt := sql_stmt ||' and oel.schedule_ship_date <= trunc( sysdate + :p_offset_days) ';
5299: /* Bug 5520934 : We need to honour bom_calendar in offset days calculation */
5300: sql_stmt := sql_stmt ||' and sysdate >= (select cal.calendar_date
5301: from bom_calendar_dates cal,
5302: mtl_parameters mp
5303: where mp.organization_id = oel.ship_from_org_id
5304: and cal.calendar_code = mp.calendar_code
5305: and cal.exception_set_id = mp.calendar_exception_set_id
5306: and cal.seq_num = (select cal2.prior_seq_num - nvl(:p_offset_days, 0)