367:
368: CURSOR c_ib(b_customer_product_id NUMBER) IS
369: SELECT serial_number
370: , lot_number
371: FROM csi_item_instances
372: WHERE instance_id = b_customer_product_id;
373:
374: Cursor C_Res_TimeZone Is
375: Select TIME_ZONE
1506:
1507: CURSOR c_ib(b_customer_product_id NUMBER) IS
1508: SELECT serial_number
1509: , lot_number
1510: FROM csi_item_instances
1511: WHERE instance_id = b_customer_product_id;
1512:
1513: Cursor C_Res_TimeZone Is
1514: Select TIME_ZONE
2476:
2477: CURSOR c_ib(b_customer_product_id NUMBER) IS
2478: SELECT serial_number
2479: , lot_number
2480: FROM csi_item_instances
2481: WHERE instance_id = b_customer_product_id;
2482:
2483: Cursor C_Res_TimeZone Is
2484: Select TIME_ZONE
3203:
3204: CURSOR c_ib(b_customer_product_id NUMBER) IS
3205: SELECT serial_number
3206: , lot_number
3207: FROM csi_item_instances
3208: WHERE instance_id = b_customer_product_id;
3209:
3210: Cursor C_Res_TimeZone Is
3211: Select TIME_ZONE