[Home] [Help]
639: FROM
640: bom_operational_routings bor
641: WHERE
642: bor.routing_sequence_id = from_sequence_id;
643: INSERT INTO mtl_interface_errors
644: (unique_id,
645: organization_id,
646: transaction_id,
647: table_name,
792: AND bos.acd_type = 3
793: AND bos.effectivity_date <= p_trgt_eff_date
794: AND bos.implementation_date IS NULL
795: );
796: INSERT INTO mtl_interface_errors
797: (unique_id,
798: organization_id,
799: transaction_id,
800: table_name,
870: AND bos.acd_type = 3
871: AND bos.effectivity_date <= p_trgt_eff_date
872: AND bos.implementation_date IS NULL
873: );
874: INSERT INTO mtl_interface_errors
875: (unique_id,
876: organization_id,
877: transaction_id,
878: table_name,
1232: */
1233: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1);
1234:
1235: IF p_log_errors = 'Y' THEN
1236: INSERT INTO mtl_interface_errors
1237: (unique_id,
1238: organization_id,
1239: transaction_id,
1240: table_name,
1333: AND bos4.operation_seq_num = bos2.operation_seq_num
1334: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1)
1335: AND mfgl.lookup_type = 'BOM_OPERATION_TYPE'
1336: AND mfgl.lookup_code = bos1.operation_type;
1337: INSERT INTO mtl_interface_errors
1338: (unique_id,
1339: organization_id,
1340: transaction_id,
1341: table_name,
1610: -- AND E.DEPARTMENT_ID = A.DEPARTMENT_ID
1611: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE;
1612:
1613: IF p_log_errors = 'Y' THEN
1614: INSERT INTO mtl_interface_errors
1615: (unique_id,
1616: organization_id,
1617: transaction_id,
1618: table_name,
1861: AND d.organization_id = to_org_id
1862: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE;
1863:
1864: IF p_log_errors = 'Y' THEN
1865: INSERT INTO mtl_interface_errors
1866: (unique_id,
1867: organization_id,
1868: transaction_id,
1869: table_name,
2663: FROM
2664: bom_operational_routings bor
2665: WHERE
2666: bor.routing_sequence_id = from_sequence_id;
2667: INSERT INTO mtl_interface_errors
2668: (unique_id,
2669: organization_id,
2670: transaction_id,
2671: table_name,
2771: AND bos.acd_type = 3
2772: AND bos.effectivity_date <= p_eco_eff_date
2773: AND bos.implementation_date IS NULL
2774: );
2775: INSERT INTO mtl_interface_errors
2776: (unique_id,
2777: organization_id,
2778: transaction_id,
2779: table_name,
2830: AND bos.effectivity_date <= p_eco_eff_date
2831: AND bos.implementation_date IS NULL
2832: );
2833:
2834: INSERT INTO mtl_interface_errors
2835: (unique_id,
2836: organization_id,
2837: transaction_id,
2838: table_name,
3173: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1)
3174: AND bos2.revised_item_sequence_id = p_rev_item_seq_id;
3175:
3176: IF p_log_errors = 'Y' THEN
3177: INSERT INTO mtl_interface_errors
3178: (unique_id,
3179: organization_id,
3180: transaction_id,
3181: table_name,
3276: AND NVL (bos4.operation_type, 1) = NVL (bos2.operation_type, 1)
3277: AND mfgl.lookup_type = 'BOM_OPERATION_TYPE'
3278: AND mfgl.lookup_code = bos1.operation_type
3279: AND bos2.revised_item_sequence_id = p_rev_item_seq_id;
3280: INSERT INTO mtl_interface_errors
3281: (unique_id,
3282: organization_id,
3283: transaction_id,
3284: table_name,
3506: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE
3507: AND a.revised_item_sequence_id = p_rev_item_seq_id;
3508:
3509: IF p_log_errors = 'Y' THEN
3510: INSERT INTO mtl_interface_errors
3511: (unique_id,
3512: organization_id,
3513: transaction_id,
3514: table_name,
3759: AND d.organization_id = to_org_id
3760: AND NVL (d.disable_date, SYSDATE + 1) > SYSDATE;
3761:
3762: IF p_log_errors = 'Y' THEN
3763: INSERT INTO mtl_interface_errors
3764: (unique_id,
3765: organization_id,
3766: transaction_id,
3767: table_name,