APPS.INV_KANBAN_PVT dependencies on BOM_CALENDAR_DATES

Line 2549: bom_calendar_dates c1,

2545: BEGIN
2546: SELECT c1.calendar_date
2547: INTO l_first_unit_start_date
2548: FROM mtl_parameters o ,
2549: bom_calendar_dates c1,
2550: bom_calendar_dates c
2551: WHERE o.organization_id = p_kanban_card_rec_tbl(1).organization_id
2552: AND c1.calendar_code = c.calendar_code
2553: AND c1.exception_set_id = c.exception_set_id

Line 2550: bom_calendar_dates c

2546: SELECT c1.calendar_date
2547: INTO l_first_unit_start_date
2548: FROM mtl_parameters o ,
2549: bom_calendar_dates c1,
2550: bom_calendar_dates c
2551: WHERE o.organization_id = p_kanban_card_rec_tbl(1).organization_id
2552: AND c1.calendar_code = c.calendar_code
2553: AND c1.exception_set_id = c.exception_set_id
2554: AND c1.seq_num = (c.next_seq_num + TRUNC(l_pre_proc_lead_time))

Line 3509: bom_calendar_dates c1,

3505: l_sql_stmt_no := 30;
3506: select c1.calendar_date
3507: into l_need_by_date
3508: from mtl_parameters o,
3509: bom_calendar_dates c1,
3510: bom_calendar_dates c
3511: where o.organization_id = l_kanban_card_Rec_Tbl(1).Organization_id
3512: and c1.calendar_code = c.calendar_code
3513: and c1.exception_set_id = c.exception_set_id

Line 3510: bom_calendar_dates c

3506: select c1.calendar_date
3507: into l_need_by_date
3508: from mtl_parameters o,
3509: bom_calendar_dates c1,
3510: bom_calendar_dates c
3511: where o.organization_id = l_kanban_card_Rec_Tbl(1).Organization_id
3512: and c1.calendar_code = c.calendar_code
3513: and c1.exception_set_id = c.exception_set_id
3514: and c1.seq_num = (c.next_seq_num + trunc(nvl(p_lead_time,l_need_by_time)))