[Home] [Help]
446: order by col.column_id;
447:
448: cursor c_primary_key is
449: select c.column_name, pkc.primary_key_sequence
450: from fnd_columns c
451: , fnd_primary_key_columns pkc
452: , fnd_primary_keys pk
453: , fnd_tables t
454: where t.application_id >= 0
565: order by col.column_id;
566:
567: cursor c_primary_key is
568: select c.column_name, pkc.primary_key_sequence
569: from fnd_columns c
570: , fnd_primary_key_columns pkc
571: , fnd_primary_keys pk
572: , fnd_tables t
573: where t.application_id >= 0
1678: table_not_found exception;
1679:
1680: cursor c_primary_key(p_table varchar2) is
1681: select c.column_name, pkc.primary_key_sequence
1682: from fnd_columns c
1683: , fnd_primary_key_columns pkc
1684: , fnd_primary_keys pk
1685: , fnd_tables t
1686: where t.application_id >= 0