DBA Data[Home] [Help]

APPS.BOMPVALR dependencies on STANDARD

Line 754: minimum_transfer_quantity MTQ, standard_operation_id SOI,

750: cursor c1 is
751: select operation_sequence_id OSI, routing_sequence_id RSI,
752: department_id DI, count_point_type CPT,
753: backflush_flag BF, option_dependent_flag ODF,
754: minimum_transfer_quantity MTQ, standard_operation_id SOI,
755: transaction_id TI, operation_lead_time_percent OLTP,
756: to_char(effectivity_date,'YYYY/MM/DD HH24:MI:SS') ED,
757: to_char(disable_date,'YYYY/MM/DD HH24:MI:SS') DD,
758: /** Changed for bug 2647027

Line 1583: ** check if basis type,standard rate flag, schedule flag

1579: goto continue_loop;
1580: end if;
1581:
1582: /*
1583: ** check if basis type,standard rate flag, schedule flag
1584: ** and autocharge type are valid
1585: */
1586: select count(*)
1587: into res_cnt

Line 1592: (standard_rate_flag not in (1, 2))

1588: from bom_op_resources_interface ori
1589: where operation_sequence_id = c1rec.OSI
1590: and ( (basis_type not in (1,2))
1591: or
1592: (standard_rate_flag not in (1, 2))
1593: or
1594: (schedule_flag not in (1,2,3,4))
1595: or
1596: (autocharge_type not in (1,2,3,4))